Need help with Excel auto fill dates
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
Here's one way to get close.
In A2 put the starting date, for example:
10/22/2017
and use the custom format
mmm-dd-yyyy-am/pm
In A3, put
=A2+0.5
and copy down as far as needed.
The result differs from the ideal by capitalization of a few letters.
Hope this helps getting started.
|