Excel date formula

  KJ823 13:02 26 Jun 05


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 05

With a date in A1


  KJ823 13:09 26 Jun 05

Excellent, thank you!

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

Hands-on: Acer Predator Triton 700 review

D&AD Awards 2017: see the best design, advertising, illustration, animation and VR of the past year

How to lose weight with an Apple Watch