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

Counting and stop counting in a cell
How to count names in excel - Guide
Conditional formatting if cell contains text - Excel Forum
If cell contains date then return value ✓ - Office Software Forum
Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
Based on the cell values in cells b77 - Excel Forum

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

counting and stop counting days in a cell

help me to add particular cells

If a cell contains any text then add a value

Formula to Find&replace blank cells in excel

Similar discussions

Subscribe To Our Newsletter!