IF Function with Date Value

Hi,

Help needed! I have a safety performance sheet in which I need to calculate the number of days without incident from an initial date. If I do not have an incident on Criterion or type of incident, then I will display the number of days since the start of the project in column C [ =TODAY()-DATEVALUE("2022/9/1") ].

Now if I have an incident, then I will enter the date of that incident in column B in order to count from that date, rather than from the initial date that is inside the formula. The formula for this should look like this: =IF(ISNUMBER(B2);TODAY()-B2;ISBLANK(B2);TODAY()-DATEVALUE("2022/9/1")).

Unfortunately, I have tried several ways of this line of arguments, and nothing is working.

Could you please help !!!

maybe like this... in C2 =DATEDIF(B2,TODAY(),"d")

Hi There is am having a problem reporting days

I have a cell with drop down in G there is a few words but the key word is Near Miss when it sees near miss i want it to look at date added in column C pulling this information and counting day from accident to today

Attachment 834186Attachment 834187