| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
moving date details
If the original date is in A1 then:
=DATE(2007,4,DAY(A1)) -- Gary''s Student gsnu200709 "rexmann" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
moving date details
=DATE(YEAR(A1)+1,4,DAY(A1))
With the date in A1 "rexmann" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
moving date details
Thanks to both of you - worked a treat
Cheers Rexmann "Mike" wrote: =DATE(YEAR(A1)+1,4,DAY(A1)) With the date in A1 "rexmann" wrote: 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 |
| Reply |
| 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 | |||
Linear Mode
