I am trying to make a pacing calendar for my employer, and I really like the Ion template that is embedded in Excel. However, it begins in January. There is a spot to put the year you'd like to begin, and it calculates everything from there. I'd like the calendar to begin in August. Because of the calendar functions built into the template, it won't let me make the changes manually, and I am not quite advanced enough with Excel to know how to fix those functions to carry over to the next year. Attached is a screenshot which shows the formula in question. I hope this makes sense. Please let me know if you need additional information.

If this can be done successfully, I will use this as my pacing calendar. I'd also like to figure out how to make an automatic countdown of days until state tests, but that's not as important. I just can't make all the other formulas work right if I try to make August my beginning. I feel like I'm missing something obvious!

Thanks for any and all help! I'd like to learn how to fix this myself, but if someone is willing to just make it work for me, I may be able to toss you a few dollars, though, as a teacher and mom of five, it won't be much.

Thanks!