In A1 I have (formatted in text with a list of all months) the month of
January is spelled out for this example.

In A2 I have the following formula: =DATEVALUE(A$1&" 1")

And then I have: =A2+1, A3+1, etc all the way down to the 31st of the month.

Ultimately the rest of the sheet will be used with vlookups to bring in data.

The help I need is when we are going into short months like February. How
can I get the last three days of the month to be blank if it does not match
the month selected in the list (A1)?

Thanks


January


Monday, January 02, 2006
Tuesday, January 03, 2006
Wednesday, January 04, 2006
Thursday, January 05, 2006
Friday, January 06, 2006
Saturday, January 07, 2006
Sunday, January 08, 2006
Monday, January 09, 2006
Tuesday, January 10, 2006
Wednesday, January 11, 2006
Thursday, January 12, 2006
Friday, January 13, 2006
Saturday, January 14, 2006
Sunday, January 15, 2006
Monday, January 16, 2006
Tuesday, January 17, 2006
Wednesday, January 18, 2006
Thursday, January 19, 2006
Friday, January 20, 2006
Saturday, January 21, 2006
Sunday, January 22, 2006
Monday, January 23, 2006
Tuesday, January 24, 2006
Wednesday, January 25, 2006
Thursday, January 26, 2006
Friday, January 27, 2006
Saturday, January 28, 2006
Sunday, January 29, 2006
Monday, January 30, 2006
Tuesday, January 31, 2006
Cummulative/Actual