software

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/2006Try this:
A1: =DATEVALUE(B1amp;quot; 1quot;)

A2:=IF(MAX(A$1:A1)gt;=EOMONTH($A$1,0),quot;quot;,A1 1)
Copy that formula down through A31

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Jimquot; wrote:

gt; Hello,
gt;
gt; In cell B1 I have a list of all months of the year. In the A column I would
gt; like to have the days of the month show depending on which month is picked.
gt; For example in the first chart I have January selected from the list. All
gt; the months of January are showing. In the second chart, February is showing
gt; in the list. In the A column all the months of February show.
gt;
gt; What formula can I use that would change these dates depending on what month
gt; is selected from the list in B1?
gt;
gt; In addition, in the months where there are short days would someone provide
gt; a formula that shows a blank cell?
gt;
gt; Thanks
gt;
gt; January (list of all months)
gt; 1/1/2006
gt; 1/2/2006
gt; 1/3/2006
gt; 1/4/2006
gt; 1/5/2006
gt; 1/6/2006
gt; 1/7/2006
gt; 1/8/2006
gt; 1/9/2006
gt; 1/10/2006
gt; 1/11/2006
gt; 1/12/2006
gt; 1/13/2006
gt; 1/14/2006
gt; 1/15/2006
gt; 1/16/2006
gt; 1/17/2006
gt; 1/18/2006
gt; 1/19/2006
gt; 1/20/2006
gt; 1/21/2006
gt; 1/22/2006
gt; 1/23/2006
gt; 1/24/2006
gt; 1/25/2006
gt; 1/26/2006
gt; 1/27/2006
gt; 1/28/2006
gt; 1/29/2006
gt; 1/30/2006
gt; 1/31/2006
gt;
gt; February (list of all months)
gt; 2/1/2006
gt; 2/2/2006
gt; 2/3/2006
gt; 2/4/2006
gt; 2/5/2006
gt; 2/6/2006
gt; 2/7/2006
gt; 2/8/2006
gt; 2/9/2006
gt; 2/10/2006
gt; 2/11/2006
gt; 2/12/2006
gt; 2/13/2006
gt; 2/14/2006
gt; 2/15/2006
gt; 2/16/2006
gt; 2/17/2006
gt; 2/18/2006
gt; 2/19/2006
gt; 2/20/2006
gt; 2/21/2006
gt; 2/22/2006
gt; 2/23/2006
gt; 2/24/2006
gt; 2/25/2006
gt; 2/26/2006
gt; 2/27/2006
gt; 2/28/2006
gt;

it did not work, any other suggestions?

quot;Ron Coderrequot; wrote:

gt; Try this:
gt; A1: =DATEVALUE(B1amp;quot; 1quot;)
gt;
gt; A2:=IF(MAX(A$1:A1)gt;=EOMONTH($A$1,0),quot;quot;,A1 1)
gt; Copy that formula down through A31
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Jimquot; wrote:
gt;
gt; gt; Hello,
gt; gt;
gt; gt; In cell B1 I have a list of all months of the year. In the A column I would
gt; gt; like to have the days of the month show depending on which month is picked.
gt; gt; For example in the first chart I have January selected from the list. All
gt; gt; the months of January are showing. In the second chart, February is showing
gt; gt; in the list. In the A column all the months of February show.
gt; gt;
gt; gt; What formula can I use that would change these dates depending on what month
gt; gt; is selected from the list in B1?
gt; gt;
gt; gt; In addition, in the months where there are short days would someone provide
gt; gt; a formula that shows a blank cell?
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt; January (list of all months)
gt; gt; 1/1/2006
gt; gt; 1/2/2006
gt; gt; 1/3/2006
gt; gt; 1/4/2006
gt; gt; 1/5/2006
gt; gt; 1/6/2006
gt; gt; 1/7/2006
gt; gt; 1/8/2006
gt; gt; 1/9/2006
gt; gt; 1/10/2006
gt; gt; 1/11/2006
gt; gt; 1/12/2006
gt; gt; 1/13/2006
gt; gt; 1/14/2006
gt; gt; 1/15/2006
gt; gt; 1/16/2006
gt; gt; 1/17/2006
gt; gt; 1/18/2006
gt; gt; 1/19/2006
gt; gt; 1/20/2006
gt; gt; 1/21/2006
gt; gt; 1/22/2006
gt; gt; 1/23/2006
gt; gt; 1/24/2006
gt; gt; 1/25/2006
gt; gt; 1/26/2006
gt; gt; 1/27/2006
gt; gt; 1/28/2006
gt; gt; 1/29/2006
gt; gt; 1/30/2006
gt; gt; 1/31/2006
gt; gt;
gt; gt; February (list of all months)
gt; gt; 2/1/2006
gt; gt; 2/2/2006
gt; gt; 2/3/2006
gt; gt; 2/4/2006
gt; gt; 2/5/2006
gt; gt; 2/6/2006
gt; gt; 2/7/2006
gt; gt; 2/8/2006
gt; gt; 2/9/2006
gt; gt; 2/10/2006
gt; gt; 2/11/2006
gt; gt; 2/12/2006
gt; gt; 2/13/2006
gt; gt; 2/14/2006
gt; gt; 2/15/2006
gt; gt; 2/16/2006
gt; gt; 2/17/2006
gt; gt; 2/18/2006
gt; gt; 2/19/2006
gt; gt; 2/20/2006
gt; gt; 2/21/2006
gt; gt; 2/22/2006
gt; gt; 2/23/2006
gt; gt; 2/24/2006
gt; gt; 2/25/2006
gt; gt; 2/26/2006
gt; gt; 2/27/2006
gt; gt; 2/28/2006
gt; gt;

Did you get an error? a wrong value?

What value is in Col_B? Is it the word quot;Januaryquot; or quot;Februaryquot; or is it a
date value?

If you received the #NAME? error, then:
Toolsgt;Add Insgt;Check: Analysis Toolpak

***********
Regards,
Ron

XL2002, WinXP-Proquot;Jimquot; wrote:

gt; it did not work, any other suggestions?
gt;
gt; quot;Ron Coderrequot; wrote:
gt;
gt; gt; Try this:
gt; gt; A1: =DATEVALUE(B1amp;quot; 1quot;)
gt; gt;
gt; gt; A2:=IF(MAX(A$1:A1)gt;=EOMONTH($A$1,0),quot;quot;,A1 1)
gt; gt; Copy that formula down through A31
gt; gt;
gt; gt; Does that help?
gt; gt;
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt; XL2002, WinXP-Pro
gt; gt;
gt; gt;
gt; gt; quot;Jimquot; wrote:
gt; gt;
gt; gt; gt; Hello,
gt; gt; gt;
gt; gt; gt; In cell B1 I have a list of all months of the year. In the A column I would
gt; gt; gt; like to have the days of the month show depending on which month is picked.
gt; gt; gt; For example in the first chart I have January selected from the list. All
gt; gt; gt; the months of January are showing. In the second chart, February is showing
gt; gt; gt; in the list. In the A column all the months of February show.
gt; gt; gt;
gt; gt; gt; What formula can I use that would change these dates depending on what month
gt; gt; gt; is selected from the list in B1?
gt; gt; gt;
gt; gt; gt; In addition, in the months where there are short days would someone provide
gt; gt; gt; a formula that shows a blank cell?
gt; gt; gt;
gt; gt; gt; Thanks
gt; gt; gt;
gt; gt; gt; January (list of all months)
gt; gt; gt; 1/1/2006
gt; gt; gt; 1/2/2006
gt; gt; gt; 1/3/2006
gt; gt; gt; 1/4/2006
gt; gt; gt; 1/5/2006
gt; gt; gt; 1/6/2006
gt; gt; gt; 1/7/2006
gt; gt; gt; 1/8/2006
gt; gt; gt; 1/9/2006
gt; gt; gt; 1/10/2006
gt; gt; gt; 1/11/2006
gt; gt; gt; 1/12/2006
gt; gt; gt; 1/13/2006
gt; gt; gt; 1/14/2006
gt; gt; gt; 1/15/2006
gt; gt; gt; 1/16/2006
gt; gt; gt; 1/17/2006
gt; gt; gt; 1/18/2006
gt; gt; gt; 1/19/2006
gt; gt; gt; 1/20/2006
gt; gt; gt; 1/21/2006
gt; gt; gt; 1/22/2006
gt; gt; gt; 1/23/2006
gt; gt; gt; 1/24/2006
gt; gt; gt; 1/25/2006
gt; gt; gt; 1/26/2006
gt; gt; gt; 1/27/2006
gt; gt; gt; 1/28/2006
gt; gt; gt; 1/29/2006
gt; gt; gt; 1/30/2006
gt; gt; gt; 1/31/2006
gt; gt; gt;
gt; gt; gt; February (list of all months)
gt; gt; gt; 2/1/2006
gt; gt; gt; 2/2/2006
gt; gt; gt; 2/3/2006
gt; gt; gt; 2/4/2006
gt; gt; gt; 2/5/2006
gt; gt; gt; 2/6/2006
gt; gt; gt; 2/7/2006
gt; gt; gt; 2/8/2006
gt; gt; gt; 2/9/2006
gt; gt; gt; 2/10/2006
gt; gt; gt; 2/11/2006
gt; gt; gt; 2/12/2006
gt; gt; gt; 2/13/2006
gt; gt; gt; 2/14/2006
gt; gt; gt; 2/15/2006
gt; gt; gt; 2/16/2006
gt; gt; gt; 2/17/2006
gt; gt; gt; 2/18/2006
gt; gt; gt; 2/19/2006
gt; gt; gt; 2/20/2006
gt; gt; gt; 2/21/2006
gt; gt; gt; 2/22/2006
gt; gt; gt; 2/23/2006
gt; gt; gt; 2/24/2006
gt; gt; gt; 2/25/2006
gt; gt; gt; 2/26/2006
gt; gt; gt; 2/27/2006
gt; gt; gt; 2/28/2006
gt; gt; gt;