Forum Discussion

Copper Contributor

Jul 24, 2020

Solved

Class schedule?

I found an Excel template a few days ago in Microsoft 365 that I can no longer find. I think it was called Class Schedule or something similar. From it I created the attached file Pat's Routines,...

Pat's Routines.xlsx25 KB

excel

Formulas and Functions

office 365

SergeiBaklan
Jul 24, 2020
ppierattemsncom

In template that's current date is inserted returned by TODAY(). Follow the instruction and replace on desired date, e.g. July 20

SergeiBaklan

Diamond Contributor

Jul 24, 2020

ppierattemsncom

In template that's current date is inserted returned by TODAY(). Follow the instruction and replace on desired date, e.g. July 20

ppierattemsncom

Copper Contributor

Jul 24, 2020

SergeiBaklan

Thanks so much! That works!

For the following week, do I just add the date of the following Monday, and everything will update (and then I can make minor adjustments on the Routine Details if necessary?)

Or do I need to enter the dates of the new week in the Routine Details section each week?

ppierattemsncom
Copper Contributor
Jul 24, 2020
ppierattemsncom

I did a Save as and I found out I did have to change the dates on the details section, because all the data disappeared. It wasn't that hard to do, and now I know!

Thanks again, Sergei Baklan
- SergeiBaklan
  Diamond Contributor
  Jul 25, 2020
  ppierattemsncom
  
  yes, you have to support Task List on the second sheet, Weekly Routine only shows this information in another form taking it for the giving category and date.