Previous Topic Next Topic

Counting and stop counting in a cell

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

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 547
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

Similar discussions

Counting cells containing only numbers
jutulu -
jutulu -

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

4 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
trying to have the current date go into one cell (A1)
dbmich -
dbmich -

3 responses