Need help with Excel auto fill dates
I'm trying to build a spreadsheet that will auto fill dates with an AM option and a pm option.
ideally, i would like it to show as follows
oct-22-2017-am
oct-22-2017-pm
oct-23-2017-am
oct-23-2017-pm
and so on down "a" until a set date, in this case it would be November 10th
horizontally I would have something like
[sit-ups] [push-ups] [run km] etc. The purpose would be to track 2 a day workouts for a 3 week period. any and all help would be greatly appreciated
|