simora
09-14-2011, 02:12 PM
I have 3 worksheets formatted exactly alike.
I need a solution so that when the user enters a month name in Cell B41 like this : October
& year in cell B42 like this : 2011
it enters the date as the 1st of that month & year in cell A2 like this :
Saturday, October 01, 2011
then copies down to the end of the month so that it creates an entry for each day of the month.
Formatted like below starting Col A 2:
Saturday, October 01, 2011
Sunday, October 02, 2011
Monday, October 03, 2011
etc etc.....
How do I format this so that it knows how many days are in that month , 28, 29, 30 or 31
This range is going to be duplicated to the 2 other sheets, and the date information will be used in other calculations.
Thanks
I need a solution so that when the user enters a month name in Cell B41 like this : October
& year in cell B42 like this : 2011
it enters the date as the 1st of that month & year in cell A2 like this :
Saturday, October 01, 2011
then copies down to the end of the month so that it creates an entry for each day of the month.
Formatted like below starting Col A 2:
Saturday, October 01, 2011
Sunday, October 02, 2011
Monday, October 03, 2011
etc etc.....
How do I format this so that it knows how many days are in that month , 28, 29, 30 or 31
This range is going to be duplicated to the 2 other sheets, and the date information will be used in other calculations.
Thanks