Forum Discussion
Date formula if dates in 1 to 4 cells
I want a formula to calculate the days (or months) an employee has worked in 2021 thus far (i.e. from TODAY'S date). An employee will have on their profile some or all of the following dates: Hire ...
2 Names with formula. Ideally you'll put them in the Name manager:
in B1 (Name = today): =TODAY()
in B2 (Name = minDate): =DATE(2021,1,1)
in F5:
=today - MAX(LOOKUP(2, 1/(B5:E5 <> ""), B5:E5), minDate)