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 Contributor 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 Contributor 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

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Counting cells containing only numbers
jutulu -
jutulu -

4 responses
counting and stop counting days in a cell
diestra123 -
diestra123 -

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

1 response
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses