Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
list formula for dates
Hello,
In cell B1 I have a list of all months of the year. In the A column I would like to have the days of the month show depending on which month is picked. For example in the first chart I have January selected from the list. All the months of January are showing. In the second chart, February is showing in the list. In the A column all the months of February show. What formula can I use that would change these dates depending on what month is selected from the list in B1? In addition, in the months where there are short days would someone provide a formula that shows a blank cell? Thanks January (list of all months) 1/1/2006 1/2/2006 1/3/2006 1/4/2006 1/5/2006 1/6/2006 1/7/2006 1/8/2006 1/9/2006 1/10/2006 1/11/2006 1/12/2006 1/13/2006 1/14/2006 1/15/2006 1/16/2006 1/17/2006 1/18/2006 1/19/2006 1/20/2006 1/21/2006 1/22/2006 1/23/2006 1/24/2006 1/25/2006 1/26/2006 1/27/2006 1/28/2006 1/29/2006 1/30/2006 1/31/2006 February (list of all months) 2/1/2006 2/2/2006 2/3/2006 2/4/2006 2/5/2006 2/6/2006 2/7/2006 2/8/2006 2/9/2006 2/10/2006 2/11/2006 2/12/2006 2/13/2006 2/14/2006 2/15/2006 2/16/2006 2/17/2006 2/18/2006 2/19/2006 2/20/2006 2/21/2006 2/22/2006 2/23/2006 2/24/2006 2/25/2006 2/26/2006 2/27/2006 2/28/2006 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
list formula for dates
Try this:
A1: =DATEVALUE(B1&" 1") A2:=IF(MAX(A$1:A1)=EOMONTH($A$1,0),"",A1+1) Copy that formula down through A31 Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Jim" wrote: Hello, In cell B1 I have a list of all months of the year. In the A column I would like to have the days of the month show depending on which month is picked. For example in the first chart I have January selected from the list. All the months of January are showing. In the second chart, February is showing in the list. In the A column all the months of February show. What formula can I use that would change these dates depending on what month is selected from the list in B1? In addition, in the months where there are short days would someone provide a formula that shows a blank cell? Thanks January (list of all months) 1/1/2006 1/2/2006 1/3/2006 1/4/2006 1/5/2006 1/6/2006 1/7/2006 1/8/2006 1/9/2006 1/10/2006 1/11/2006 1/12/2006 1/13/2006 1/14/2006 1/15/2006 1/16/2006 1/17/2006 1/18/2006 1/19/2006 1/20/2006 1/21/2006 1/22/2006 1/23/2006 1/24/2006 1/25/2006 1/26/2006 1/27/2006 1/28/2006 1/29/2006 1/30/2006 1/31/2006 February (list of all months) 2/1/2006 2/2/2006 2/3/2006 2/4/2006 2/5/2006 2/6/2006 2/7/2006 2/8/2006 2/9/2006 2/10/2006 2/11/2006 2/12/2006 2/13/2006 2/14/2006 2/15/2006 2/16/2006 2/17/2006 2/18/2006 2/19/2006 2/20/2006 2/21/2006 2/22/2006 2/23/2006 2/24/2006 2/25/2006 2/26/2006 2/27/2006 2/28/2006 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
list formula for dates
it did not work, any other suggestions?
"Ron Coderre" wrote: Try this: A1: =DATEVALUE(B1&" 1") A2:=IF(MAX(A$1:A1)=EOMONTH($A$1,0),"",A1+1) Copy that formula down through A31 Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Jim" wrote: Hello, In cell B1 I have a list of all months of the year. In the A column I would like to have the days of the month show depending on which month is picked. For example in the first chart I have January selected from the list. All the months of January are showing. In the second chart, February is showing in the list. In the A column all the months of February show. What formula can I use that would change these dates depending on what month is selected from the list in B1? In addition, in the months where there are short days would someone provide a formula that shows a blank cell? Thanks January (list of all months) 1/1/2006 1/2/2006 1/3/2006 1/4/2006 1/5/2006 1/6/2006 1/7/2006 1/8/2006 1/9/2006 1/10/2006 1/11/2006 1/12/2006 1/13/2006 1/14/2006 1/15/2006 1/16/2006 1/17/2006 1/18/2006 1/19/2006 1/20/2006 1/21/2006 1/22/2006 1/23/2006 1/24/2006 1/25/2006 1/26/2006 1/27/2006 1/28/2006 1/29/2006 1/30/2006 1/31/2006 February (list of all months) 2/1/2006 2/2/2006 2/3/2006 2/4/2006 2/5/2006 2/6/2006 2/7/2006 2/8/2006 2/9/2006 2/10/2006 2/11/2006 2/12/2006 2/13/2006 2/14/2006 2/15/2006 2/16/2006 2/17/2006 2/18/2006 2/19/2006 2/20/2006 2/21/2006 2/22/2006 2/23/2006 2/24/2006 2/25/2006 2/26/2006 2/27/2006 2/28/2006 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
list formula for dates
Did you get an error? a wrong value?
What value is in Col_B? Is it the word "January" or "February" or is it a date value? If you received the #NAME? error, then: ToolsAdd InsCheck: Analysis Toolpak *********** Regards, Ron XL2002, WinXP-Pro "Jim" wrote: it did not work, any other suggestions? "Ron Coderre" wrote: Try this: A1: =DATEVALUE(B1&" 1") A2:=IF(MAX(A$1:A1)=EOMONTH($A$1,0),"",A1+1) Copy that formula down through A31 Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Jim" wrote: Hello, In cell B1 I have a list of all months of the year. In the A column I would like to have the days of the month show depending on which month is picked. For example in the first chart I have January selected from the list. All the months of January are showing. In the second chart, February is showing in the list. In the A column all the months of February show. What formula can I use that would change these dates depending on what month is selected from the list in B1? In addition, in the months where there are short days would someone provide a formula that shows a blank cell? Thanks January (list of all months) 1/1/2006 1/2/2006 1/3/2006 1/4/2006 1/5/2006 1/6/2006 1/7/2006 1/8/2006 1/9/2006 1/10/2006 1/11/2006 1/12/2006 1/13/2006 1/14/2006 1/15/2006 1/16/2006 1/17/2006 1/18/2006 1/19/2006 1/20/2006 1/21/2006 1/22/2006 1/23/2006 1/24/2006 1/25/2006 1/26/2006 1/27/2006 1/28/2006 1/29/2006 1/30/2006 1/31/2006 February (list of all months) 2/1/2006 2/2/2006 2/3/2006 2/4/2006 2/5/2006 2/6/2006 2/7/2006 2/8/2006 2/9/2006 2/10/2006 2/11/2006 2/12/2006 2/13/2006 2/14/2006 2/15/2006 2/16/2006 2/17/2006 2/18/2006 2/19/2006 2/20/2006 2/21/2006 2/22/2006 2/23/2006 2/24/2006 2/25/2006 2/26/2006 2/27/2006 2/28/2006 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
How can I add a new formula to Excel formula list | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |