ExcelBanter - synchronizing the years for multiple dates

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - synchronizing the years for multiple dates (https://www.excelbanter.com/excel-discussion-misc-queries/52200-re-synchronizing-years-multiple-dates.html)

Dave O

synchronizing the years for multiple dates

This formula will do it for you:
=DATE(2005,MONTH(A1),DAY(A1))

.... where the 1/1/2001 entry is in cell A1.

All times are GMT +1. The time now is 10:50 PM.