Re: Calendar Output
Quote from SerenityNetwork
Since the original was in Sunday through Saturday format, I just changed your idea to put the following in C4 and then fill-right over to I4.
Doh! But now that I think about it, it doesn't make any difference does it? The formula will label the columns correctly regardless of the weekday option (1 or 2) chosen.
Anyway, I wanted to ask you, [COLOR="Blue"]"What did you mean by, 'For each Day cell, i changed $C$$ to $D$4 etc.'?"[/COLOR] I'm not following you.
It's a typo, I can't remember now, it was quite early when I was playing
Also, I was just thinking... I think I could use a couple of formulas, so that you just put in the month in C2 then the date cells would fill out automatically, as-well-as the weekend and previous/following month days would be appropriately colored. If I get time in the next few days, I may go for doing it.
I have been playing with it and added conditional formatting to colour the cells for the next month grey, just need to add similar for weekends. I did change your Weekday formula in the CF on the Data Sheet so that day 1 is a Monday, so now it only needs one Format - =WEEKDAY(A5,2)>5