Excel date formula

  KJ823 13:02 26 Jun 2005


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.


  VoG II 13:06 26 Jun 2005

With a date in A1


  KJ823 13:09 26 Jun 2005

Excellent, thank you!

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 ?