Thread
:
synchronizing the years for multiple dates
View Single Post
#
1
Dave O
Posts: n/a
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.
Reply With Quote