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

OnePlus 5T review: Hands-on

Illustrator Andrés Lozano on his improv line work, brazen use of colours & hand sketching

iPhone X review

Comment envoyer gratuitement des gros fichiers ?