Previous Topic Next Topic

Counting and stop counting in a cell

Closed
jerome - Jun 20, 2022 at 12:02 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 21, 2022 at 12:02 PM
Hello,

I need to create a formula for a cell involving number of days between dates.

A2 - start date
B2 - lead time
C2 - end date
D2 - showing ok/not

the main objective is count the lead time (B2) when the date input in (A2), and stop the counting in (B2) when the date entered in (C3), showing status in (D2)

Any help would be very much appreciated.
Thanks.




System Configuration: Windows / Chrome 102.0.0.0

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Jun 21, 2022 at 12:02 PM
Hi Jerome,

So basically you want to count the days between the start date and today's date until there is entered an end date, then you want to count the days between the start date and the end date.

This formula will do that for you:
=IF(C2="",DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))-A2,C2-A2)

Best regards,
Trowa

Similar discussions

Counting cells containing only numbers
jutulu -
jutulu -

4 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

1 response
counting and stop counting days in a cell
diestra123 -
diestra123 -

4 responses