retirement dates

[tecia88]

Hi

I need to work out who i would contact for retirement 8 months before there 65 birthday

I have there date of birth in B2 and i want to put the date it will be 8 months before there 65th birthday in C2

Can anyone help

Thank you

 

[schielrn]

Maybe try:

=date(year(B2)+65,month(B2)-8,day(B2))

Hope that helps.

 

[tecia88]

thank you for your reply!

i have one more question i am trying to work out length of service so i thought i could use the same formula.

so B2 would be there start date and then i would need to know what the date and year would be 5,10,15,20 years from there start date.

i changed the -8 to +10 and it didnt work...it multiplied the years....

Can you help

Thank you x

 

[onlyadrafter]

Hello,

alternativey use

=EDATE($B2,(65*12)-8) for the retirement date

and

=EDATE($B2,5*12) for 5 years service,

change the 5 for other years of service.

 

[tecia88]

Thank you

I have another hard one

can you let me know how i would work out if someone has done 10 weeks plus service as of the 01/01/2009

so i have there start date in b2 i will need the result in c2

thank you
x

 

[onlyadrafter]

Hello,

depends on how you determine 10 weeks

=IF(39814-B1>70,"10 WEEKS","")

this checks for 70 days.

=IF(B1<39744,"10 weeks","")

this checks for a start date before 23/10/08.