Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
moving date details
Hi All
Wondered if you could help with the following on Excel: I would like to convert a series of dates (from different months in 2006) to the month of April 2007, but to keep the day of the month i.e. 1st or 2nd the same. See below: Old New 01/08/2006 01/04/2007 03/09/2006 03/04/2007 04/10/2006 04/04/2007 11/10/2006 11/04/2007 Is there a way to do this on Excel? I am using Excel 2002 (and in UK so other way around to USA). Any help greatly appreciated Kind regards Rexmann |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate prior calendar year end from a moving current date | Excel Worksheet Functions | |||
MOVING DATE RANGE ON A CHART | Charts and Charting in Excel | |||
Calculate a 30-day moving average based on the last x number of entries and date | Excel Worksheet Functions | |||
Moving data based on date ranges | Excel Worksheet Functions | |||
Moving numbers from one sheet to another by date | Excel Worksheet Functions |