Current Events > Is there a way to auto-populate multiple dates from one input in Excel?

(+) Yeah! (+)

I want to update a lifting chart so that when I enter one date, the others will auto-populate. So when I enter, for instance June 2, on the first Wednesday, all the other dates will populate. My weights already auto populate and calculate.

Ideally, I'd be able to just enter the first Wednesday of the Monday (red) and have future duplicate Wednesdays populate (yellow) as well as filling in the blanks for the other days of that week (blue) and future dates (green).

(see below)


---