SOLVED

Class schedule?

%3CLINGO-SUB%20id%3D%22lingo-sub-1544552%22%20slang%3D%22en-US%22%3EClass%20schedule%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1544552%22%20slang%3D%22en-US%22%3E%3CP%3EI%20found%20an%20Excel%20template%20a%20few%20days%20ago%20in%20Microsoft%20365%20that%20I%20can%20no%20longer%20find.%20I%20think%20it%20was%20called%20Class%20Schedule%20or%20something%20similar.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EFrom%20it%20I%20created%20the%20attached%20file%20Pat's%20Routines%2C%20and%20got%20the%20spacing%20and%20everything%20how%20I%20wanted%20it%20yesterday.%20However%2C%20this%20morning%2C%20everything%20shifted%20by%20a%20day%2C%20so%20it%20showed%20Church%20occurring%20on%20Monday%2C%20for%20instance.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI'm%20not%20understanding%20exactly%20how%20this%20chart%20works%2C%20except%20that%20the%20Schedule%20Start%20Date%20apparently%20updates%20every%20day%20and%20switches%20all%20the%20data.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20there%20a%20way%20to%20%22lock%22%20the%20data%20I've%20inputted%20so%20things%20don't%20shift%20to%20the%20wrong%20days%3F%26nbsp%3B%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EDo%20I%20need%20to%20keep%20entering%20all%20the%20dates%20and%20task%20descriptions%2C%20or%20is%20there%20a%20way%20to%20make%20the%20weekly%20data%20repeat%20again%20starting%20each%20Monday%3F%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EOr%20do%20I%20just%20need%20to%20print%20it%20each%20Monday%20when%20the%20data%20is%20correct%3F%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20in%20advance!%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1544552%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1544644%22%20slang%3D%22en-US%22%3ERe%3A%20Class%20schedule%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1544644%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F739344%22%20target%3D%22_blank%22%3E%40ppierattemsncom%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20template%20that's%20current%20date%20is%20inserted%20returned%20by%20TODAY().%20Follow%20the%20instruction%20and%20replace%20on%20desired%20date%2C%20e.g.%20July%2020%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20322px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F207722i5DD806A5945CA81B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1544759%22%20slang%3D%22en-US%22%3ERe%3A%20Class%20schedule%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1544759%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20so%20much!%26nbsp%3B%20That%20works!%3CBR%20%2F%3E%3CBR%20%2F%3EFor%20the%20following%20week%2C%20do%20I%20just%20add%20the%20date%20of%20the%20following%20Monday%2C%20and%20everything%20will%20update%20(and%20then%20I%20can%20make%20minor%20adjustments%20on%20the%20Routine%20Details%20if%20necessary%3F)%3CBR%20%2F%3E%3CBR%20%2F%3EOr%20do%20I%20need%20to%20enter%20the%20dates%20of%20the%20new%20week%20in%20the%20Routine%20Details%20section%20each%20week%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1544885%22%20slang%3D%22en-US%22%3ERe%3A%20Class%20schedule%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1544885%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F739344%22%20target%3D%22_blank%22%3E%40ppierattemsncom%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20did%20a%20Save%20as%20and%20I%20found%20out%20I%20did%20have%20to%20change%20the%20dates%20on%20the%20details%20section%2C%20because%20all%20the%20data%20disappeared.%20It%20wasn't%20that%20hard%20to%20do%2C%20and%20now%20I%20know!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20again%2C%20Sergei%20Baklan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1545657%22%20slang%3D%22en-US%22%3ERe%3A%20Class%20schedule%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1545657%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F739344%22%20target%3D%22_blank%22%3E%40ppierattemsncom%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eyes%2C%20you%20have%20to%20support%20Task%20List%20on%20the%20second%20sheet%2C%20Weekly%20Routine%20only%20shows%20this%20information%20in%20another%20form%20taking%20it%20for%20the%20giving%20category%20and%20date.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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, and got the spacing and everything how I wanted it yesterday. However, this morning, everything shifted by a day, so it showed Church occurring on Monday, for instance. 

I'm not understanding exactly how this chart works, except that the Schedule Start Date apparently updates every day and switches all the data. 

Is there a way to "lock" the data I've inputted so things don't shift to the wrong days?  

Do I need to keep entering all the dates and task descriptions, or is there a way to make the weekly data repeat again starting each Monday? 

Or do I just need to print it each Monday when the data is correct? 

Thanks in advance!


4 Replies
Best Response confirmed by ppierattemsncom (New Contributor)
Solution

@ppierattemsncom 

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

image.png

 

@Sergei Baklan 

 

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 

 

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

@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.