Skrej
Board Regular
- Joined
- May 31, 2013
- Messages
- 159
- Office Version
- 365
- Platform
- Windows
I'm trying to figure out a formula for an attendance roster that will calculate the first M/W/F of a month. Since this particular class only meets M/W/F, I'd like to generate an attendance roster that for each month (each month on separate sheet) which finds the first day of the month that's either a M/W/F, then calculate all the subsequent M/W/F days, skipping over weekends, etc. The in the row above, calculate which day of the week that date is
Here's a partially completed example of what September 2019 would look like:
<tbody>
</tbody>
I've been playing with some formulas I've googled, but can't quite seem to get them pieced together.
thanks in advance
Here's a partially completed example of what September 2019 would look like:
Mon | Wed | Friday | Mon | Wed | Friday | Mon | Wed | Fri |
9/2 | 9/4 | 9/6 | 9/9 | 9/11 | 9/13 | 9/16 | 9/18 | 9/20 |
<tbody>
</tbody>
I've been playing with some formulas I've googled, but can't quite seem to get them pieced together.
thanks in advance
Last edited: