Calculation

[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

 

[Don Guillett]

is column A (age) an age like 35 or a date of birth?
same question for col B

 

[Guest]

Hi, sorry....

Both colums are dates (i.e. 03-Mar-43).

Thanks,

Teri

 

[Don Guillett]

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")