Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question about modifying dates
I have a large spreadsheets with a list of events and 2 columns for dates.
The date that the even was originally scheduled for and the date that it actually happened. The events go into next year and just realized that starting Jan 1, 2009 the dates are erronously listed in the format 01/01/08 as 2008. So I need to update all the dates from Jan forward to read XX/XX/09, how can I do this without affecting the 2008 dates. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question regarding dates | Excel Worksheet Functions | |||
Question regarding Dates | Excel Discussion (Misc queries) | |||
If Then Question Regarding Dates | Excel Worksheet Functions | |||
Modifying a Formula / OR Question | Excel Worksheet Functions | |||
Another question regarding Dates.. | Excel Discussion (Misc queries) |