Count number of days from date 1 (E2) to today (L1), unless there is a date 2 (F2)

[Tazzbjs]

I know this will be a simple one... I need to calculate the number of days from an employee's hire date (E2) to today ($L$1), unless there is an event date (F2). I would greatly appreciate any help.

Employee ID	Last Name	First Name	Location	Hire Date	Last Preventable Acc	Yrs without Prev Acc				Today	7/23/2024​
111111	Aaron	Mike	TX	6/17/2015

 

[Joe4]

Try:

=IF(F2>0,F2-E2,TODAY()-E2)

 

[Tazzbjs]

Try:

=IF(F2>0,F2-E2,TODAY()-E2)

Close... The second image should be 365 days. Just needed a small change. But you got me there much faster. Thank-you

Corrected Code

=IF(F2>0,TODAY()-F2,TODAY()-E2)

 

[Joe4]

Close... The second image should be 365 days. Just needed a small change. But you got me there much faster. Thank-you

Corrected Code

=IF(F2>0,TODAY()-F2,TODAY()-E2)

View attachment 114398
View attachment 114399

Ah, well your description left the door open to interpretation, as it did not explicitly say exactly what you wanted to do when there was a date in F2:

I know this will be a simple one... I need to calculate the number of days from an employee's hire date (E2) to today ($L$1), unless there is an event date (F2).

So it was unclear whether you wanted to subtract E2 from F2 in that case, or F2 from today.

In any event, I am glad you were able to see the logic to use, and incorporate into what you needed to do.

 

[Peter_SSs]

Corrected Code

=IF(F2>0,TODAY()-F2,TODAY()-E2)

Would this one also work for you? It assumes any date in F2 would not be before the Hire date.

=TODAY()-MAX(E2:F2)