Excel date formula

  KJ823 13:02 26 Jun 05
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 05

With a date in A1

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

  KJ823 13:09 26 Jun 05

Excellent, thank you!
KJ

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