My wife is a teacher and I'm working on automating some of her redundant tasks. One of those tasks is creating track sheets that allow her to keep track of assignments for her students. However, there's a portion of the coding that will involve dates and stuff like that and I'm and not sure how to accomplish the desired result.
Here's what I need to do:
I need to create a listing of dates for a two week period (not including weekends, so it would be 10 dates total). The list would be something like this:
May 2 | May 3 | May 4 | May 5 | May 6 | May 9 | May 10 | May 11 | May 12 | May 13
But here's the kicker... I need the dates to start on the following MONDAY no matter what day the sheet is being generated on.
I hope someone can help me figure out the coding for this. I will greatly appreciate it and so will my wife.