HiI 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.ThanksKJ
With a date in A1=DATE(YEAR(A1)+25,MONTH(A1),DAY(A1))
Excellent, thank you!KJ
This thread is now locked and can not be replied to.
Best phone camera 2017
Stunning new film posters by Hattie Stewart, Joe Cruz & more
iPad Pro 10.5in (2017) review
28 astuces pour profiter au mieux de votre iPhone
© Copyright 2017 IDG UK. All Rights Reserved.