Counting and stop counting in a cell

jerome - Jun 20, 2022 at 12:02 PM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 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 reply

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
514
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
0