Home |
Search |
Today's Posts |
#1
|
|||
|
|||
synchronizing the years for multiple dates
In a new column, add
=DATE(YEAR(TODAY()),MONTH(A1),DAY(A1)) copy down, then copy and pastespecial as values and delete the original column of dates -- HTH RP (remove nothere from the email address if mailing direct) "Davidjd" wrote in message ... I have many dates that I need to sychronize the year on. For example: 1/1/2001, 1/1/2002, 1/1/2005 all need to say 1/1/2005. It's a long list of different dates all needing the 2005 as their current year. Retyping isn't an option. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
synchronizing the years for multiple dates | Excel Discussion (Misc queries) | |||
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 | |||
How do I display months and years between two dates | Excel Discussion (Misc queries) |