Calander.png
I have a calander that needs to be set up per the above/attached format. The weekend days are shaded in blue. Anyone know of a way to get the weekend days to format to blue based on the year typed in cell A1?
Basically, I need it to look at the year in A1, and if the intersect of the Month and Day fo that year falls on a Saturday or Sunday, I need it to format that cell.
I want this to update when the year is changed in A1.
Thanks,
John
Bookmarks