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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

VFX Oscar nominees 2017: Discover how the visual effects were created

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…