Calculation

  • Thread starter Thread starter Teri
  • Start date Start date
T

Teri

Hi,

I've been asked to create a spreadsheet which requires a
formula. I currently have three columns (Age, Date of
Hire, Unreduced). I need the "Undreduced" column to
either say "No" or "Yes" based on the total of the
person's age and years of service are equal to or greater
than 90.

Any help would be appreciated.

Thanks

Teri
 
I didn't ask you what date you were using for an "AS OF" ,so I assumed
today.
where d2 is the date of birth and e2 is the date of hire.

=IF(DATEDIF(D2,TODAY(),"y")+DATEDIF(E2,TODAY(),"Y")>=90,"over","not over")
 
Back
Top