Forum Discussion
3-mo calendar - starting on a particular date
Please test carefully.
Here's a pic of my idea.
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
HansVogelaar Sure! Attached.
Please test carefully.
Can I ask one follow-up question? I've changed some of the colors, etc. - nothing major. I also added a new tab to calculate the actual 2nd-stage window when the actual date of the 1st-stage is known. In each tab, I notice that the conditional formatting for the 2nd-stage window highlights empty cells if the window involves 2 months - cells that correspond to dates from the previous month above it. The 1st-stage window highlights only the active dates for the full two weeks - none of the inactive cells in the 2nd month. In looking at the conditional formatting, I can't figure out how to make this stop. Any thoughts?
Thank you again - I'm just blown away. You have no idea how helpful this is.