I'll give it a shot with the formula. Yes, I want to also eliminate the bottom blank row if the last day of the month falls on a Sunday.
Thanks for your help!
Yes, since the week runs Sun to Sat I don't want the first week to show up if the 1st is a Sat. I'm not sure I understand your manual solution. Wouldn't it always exclude week 1 regardless of what day it starts on?
The part about showing only the months with activity I figured out on my own...
OK, how do I show only the months that have activity in the original report? They would be contiguous.
Since I am not showing Sat and Sun, I want my January 2011 calendar to start on Mon, Jan. 3. What I am getting is a blank first row. The second row starts with 3rd.
I am working on a calendar-style report that I based on the tips in this thread:
http://www.tek-tips.com/viewthread.cfm?qid=1475890&page=4
BTW, Linda Bass, you're a gem! Your amazing advice got me this far, but now I'm stumped. I need to show course schedules that span several months, like if...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.