I have a calendar of sorts, it's actually a timesheet using a calendar format. I have it auto populating the days/dates after enter the month and year, and I set it up to only calculate the work weeks, not weekends. Everything is working well, but I would like to have it only show the first workday of the month and end on the last work day and not show any dates from the previous or next month. I've included a screen shot of the pertinent parts with formulas shown.
ExcelTimeSheet.PNG
Bookmarks