Forum Discussion
How to produce a value for every nth value
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, arm...
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.
Put the following two formulas into cells A2 and B2:
=SEQUENCE( 92, 1, DATE(2024,6,21) )
=CHOOSE( WEEKDAY(SEQUENCE(92, 1, A2, 1)), "Legs", "", "Chest", "Arms", "Legs", "Chest", "Arms" )
(Spaces are included for readability, but are not required.)
Edit: Oh, and of course, format column A for dates, possibly with a custom number format such as (ddd) mmm dd, yyyy
Thank you SnowMan55,
How about if I wanted the sequence of gym workouts to go horizontally and the dates vertically?
coropeza "workouts to go horizontally and the dates vertically" can be interpreted multiple ways. Do you want this:
or this:
or this:
or something else?
See the attached workbook.
- 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.