How to produce a value for every nth value

Question

I am trying to create a schedule for going to the gym. I go to the gym every day except Monday. So Tuesday I would do chest, Wednesday Arms, Thursday Legs and then it resets with chest on Friday, arms on Saturday. I have a list a dates scheduled out for 3 months starting from 6/21/24. How do I dynamically make it so every time the date is Tuesday-Sunday, it will automatically reset to chest or arms or legs in order while skipping Mondays for the next two months.&nbsp;

snowman55 · Answer

coropeza&nbsp;Your plan is to rotate through three activities in a six-day period (followed by a seventh day off). So every weekday will have a consistent activity.&nbsp;Put the following two formulas into cells A2 and B2:&nbsp;=SEQUENCE( 92, 1, DATE(2024,6,21) )
=CHOOSE( WEEKDAY(SEQUENCE(92, 1, A2, 1)), "Legs", "", "Chest", "Arms", "Legs", "Chest", "Arms" )&nbsp;(Spaces are included for readability, but are not required.)&nbsp;Edit: Oh, and of course, format column A for dates, possibly with a custom number format such as (ddd) mmm dd, yyyy

coropeza · Answer

Thank you&nbsp;SnowMan55,&nbsp;&nbsp;How about if I wanted the sequence of gym workouts to go horizontally and the dates vertically?

snowman55 · Answer

coropeza&nbsp;"workouts to go horizontally and the dates vertically" can be interpreted multiple ways.&nbsp; Do you want this:&nbsp;or this:&nbsp;or this:&nbsp;or something else?&nbsp;See the attached workbook.

coropeza · Answer

Sorry, I should have added I have times ranging from 5:30-12PM to correspond with the dates horizontally. So dates go down vertically and times go across horizontally.

Forum Discussion

How to produce a value for every nth value

4 Replies

Resources