Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i sort dates by months and not years? | New Users to Excel | |||
Changing dates entered in 2005 to previous years | Excel Worksheet Functions | |||
count number of years 2003 in a range of dates | Excel Worksheet Functions | |||
difference between two dates in years, months and days. | Excel Worksheet Functions | |||
How do I display months and years between two dates | Excel Discussion (Misc queries) |