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

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


--
Don Guillett
SalesAid Software

"Teri" wrote in message
...
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

Hi, sorry....

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

Thanks,

Teri

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


--
Don Guillett
SalesAid Software

"Teri" wrote in
message
...
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")

--
Don Guillett
SalesAid Software

wrote in message
...
Hi, sorry....

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

Thanks,

Teri

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


--
Don Guillett
SalesAid Software

"Teri" wrote in
message
...
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


.