Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date lists
In Excel 2003 I wish to create a list where cell A1 contains a starting date
with a formula in cell A2 that has the same day in the next month same year Cell A3 continues the list e.g. A1 = 01/01/2009, A2=01/02/2009, A3=01/03/209 I have used the formula =DATE(YEAR(year)+value1,MONTH(month)+value2,DAY(da y)+value3) as described in various other ares BUT when the date in A1 is 31/01/2009, cell A2 displays the date as 04/03/09. The formula also need to show that if A1=31/01/2009, then A2=28/02/2009, A3=31/03/2009. Also need to account for leap years All help appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date lists
In A2:
=EDATE(A$1,ROW()-1) and fill it down! Analysis Toolpak is required to use this function! Regards, Stefi €˛Mokka€¯ ezt Ć*rta: In Excel 2003 I wish to create a list where cell A1 contains a starting date with a formula in cell A2 that has the same day in the next month same year Cell A3 continues the list e.g. A1 = 01/01/2009, A2=01/02/2009, A3=01/03/209 I have used the formula =DATE(YEAR(year)+value1,MONTH(month)+value2,DAY(da y)+value3) as described in various other ares BUT when the date in A1 is 31/01/2009, cell A2 displays the date as 04/03/09. The formula also need to show that if A1=31/01/2009, then A2=28/02/2009, A3=31/03/2009. Also need to account for leap years All help appreciated. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date lists
So easy!
Many Thanks "Stefi" wrote: In A2: =EDATE(A$1,ROW()-1) and fill it down! Analysis Toolpak is required to use this function! Regards, Stefi €˛Mokka€¯ ezt Ć*rta: In Excel 2003 I wish to create a list where cell A1 contains a starting date with a formula in cell A2 that has the same day in the next month same year Cell A3 continues the list e.g. A1 = 01/01/2009, A2=01/02/2009, A3=01/03/209 I have used the formula =DATE(YEAR(year)+value1,MONTH(month)+value2,DAY(da y)+value3) as described in various other ares BUT when the date in A1 is 31/01/2009, cell A2 displays the date as 04/03/09. The formula also need to show that if A1=31/01/2009, then A2=28/02/2009, A3=31/03/2009. Also need to account for leap years All help appreciated. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date lists
You are welcome! Thanks for the feedback!
Stefi €˛Mokka€¯ ezt Ć*rta: So easy! Many Thanks "Stefi" wrote: In A2: =EDATE(A$1,ROW()-1) and fill it down! Analysis Toolpak is required to use this function! Regards, Stefi €˛Mokka€¯ ezt Ć*rta: In Excel 2003 I wish to create a list where cell A1 contains a starting date with a formula in cell A2 that has the same day in the next month same year Cell A3 continues the list e.g. A1 = 01/01/2009, A2=01/02/2009, A3=01/03/209 I have used the formula =DATE(YEAR(year)+value1,MONTH(month)+value2,DAY(da y)+value3) as described in various other ares BUT when the date in A1 is 31/01/2009, cell A2 displays the date as 04/03/09. The formula also need to show that if A1=31/01/2009, then A2=28/02/2009, A3=31/03/2009. Also need to account for leap years All help appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NetWorkDays - lists as Date?? | Excel Discussion (Misc queries) | |||
LISTS- adding info without repeat to other lists | Excel Discussion (Misc queries) | |||
Lists referencing lists...is it possible? | Excel Worksheet Functions | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
lists from other lists in excel | Excel Worksheet Functions |