Study Effort Auto-Populator

%3CLINGO-SUB%20id%3D%22lingo-sub-2560745%22%20slang%3D%22en-US%22%3EStudy%20Effort%20Auto-Populator%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2560745%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20Excel%20Fam!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20create%20an%20auto-populating%20study%20plan%20in%20excel%20and%20have%20run%20into%20some%20problems.%20I%20am%20on%20Windows%2010%20using%20Microsoft%20365%20Online%20(mostly)%20and%20would%20like%20to%20be%20able%20to%20fill%20out%20my%20study%20topics%20and%20the%20dates%20(blue%20text)%20that%20I%20am%20going%20to%20start%20studying.%20Then%20the%20field%20(yellow%20section)%20auto-populate%20with%20the%20effort%20hours%20to%20the%20pattern%20shown.%20The%20pattern%20adds%20an%20additional%20day%20every%20time%20I%20review%20the%20material%20(%20expect%20the%20first%20time%20I%20review%20the%20material).%20This%20will%20help%20me%20adjust%20my%20start%20dates%20incase%20I%20see%20a%20major%20spike%20in%20effort%20due%20to%20my%20harder%20classes%20verses%20easier%20ones.%20I%20though%20of%20using%20a%20counter%20at%20the%20top%20of%20the%20sheet%20(italicized%20numbers)%20but%20I'm%20not%20sure%20how%20to%20keep%20increasing%20the%20breaks.%20I%20also%20though%20of%20counting%20the%20previous%20number%20of%20review%20sessions%20to%20add%20the%20gaps%20but%20I%20don't%20know%20how%20to%20let%20the%20cells%20that%20are%20%22breaks%22%20to%20not%20be%20a%20value.%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20and%20all%20help%20would%20be%20so%20greatly%20appreciated!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2560745%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
Occasional Visitor

Hey Excel Fam!

 

I'm trying to create an auto-populating study plan in excel and have run into some problems. I am on Windows 10 using Microsoft 365 Online (mostly) and would like to be able to fill out my study topics and the dates (blue text) that I am going to start studying. Then the field (yellow section) auto-populate with the effort hours to the pattern shown. The pattern adds an additional day every time I review the material ( expect the first time I review the material). This will help me adjust my start dates incase I see a major spike in effort due to my harder classes verses easier ones. I though of using a counter at the top of the sheet (italicized numbers) but I'm not sure how to keep increasing the breaks. I also though of counting the previous number of review sessions to add the gaps but I don't know how to let the cells that are "breaks" to not be a value. 

Any and all help would be so greatly appreciated!

0 Replies