Excel date formula

  KJ823 13:02 26 Jun 2005
Locked

Hi

I have a spreadsheet which includes the start date for a number of employees.

I want to work out when they will have completed 25 years service.

Please could someone tell me what formula I need to use to add 25 years to each date.

Thanks
KJ

  VoG II 13:06 26 Jun 2005

With a date in A1

=DATE(YEAR(A1)+25,MONTH(A1),DAY(A1))

  KJ823 13:09 26 Jun 2005

Excellent, thank you!
KJ

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone