Hi,
I've attached a file that I am working with. The process I need to follow this this...
In cell B2 I enter the current year. Cell D1 should always be 1 for January. Cell A5 should display as 'mmmm yyyy' based off of B2+D1.
I want to take that information and automatically adjust cells B7 through B48 (if necessary) to display the day. Cells A7 through A48 show as Su, M, Tu, W, etc.
So if it is the year 2013 I want cell B7 to be blank, B8 to be blank, but since January 1 2013 is on a Tuesday I want B9 (Tu from A9) to display as 1, B10 (W from A10) will display as 2. This will repeat on down the line through the 31st where B37 will display as 31.
Does that make sense to anyone?
I will eventually have another set of columns that will do the same thing for every month of the year. But hopefully I can figure that out on my own once I see the main example.
Help would be appreciated!
Sample.xlsx
Bookmarks