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.

What is Amazon Go and will it come to the UK? The store without checkouts or queues

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

Hands-on with the Star Wars fighting drones you can fly yourself

iPhone 9 and beyond: 32 amazing future smartphone developments - graphene, supercapacitor…