ExcelBanter - How can I add 3 years to date 03/05/2003

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How can I add 3 years to date 03/05/2003 (https://www.excelbanter.com/excel-worksheet-functions/83536-how-can-i-add-3-years-date-03-05-2003-a.html)

mesh

How can I add 3 years to date 03/05/2003

Ardus Petus

How can I add 3 years to date 03/05/2003

Assuming you have 03/05/2003 in A1, enter:
=DATE(YEAR(A1)+3,MONTH(A1),DAY(A1))

--
AP

"mesh" a écrit dans le message de
...

All times are GMT +1. The time now is 11:37 PM.