multiple If's based on today's date
I need to have the value of a cell based on the number of days past from a
date in another cell. i.e. A1 = 40 if A2 [date] is <=today()+365 or, A1=80
if A2 is =today+365 but <=1460. The idea is anual vacation paid based on
hire date.
|