0
I want to know how I can have sequential dates in a row Example I need the dates to show in this format Cell m1 Monday, June 3, 2017 Cell 2 Tuesday, June 4, 2017 Cell 3 Wednesday, June 5, 2017
And continuing to end of year
0
I want to know how I can have sequential dates in a row Example I need the dates to show in this format Cell m1 Monday, June 3, 2017 Cell 2 Tuesday, June 4, 2017 Cell 3 Wednesday, June 5, 2017
And continuing to end of year
0
To clarify Vylix's comment, I start with a couple of assumptions. If these are not valid, then adjust the instructions as appropriate:
Then just follow these steps:
Do two things: type
6/3/2017
until6/5/2017
, and drag it down until12/31/2017
, then format the ranges asDate
with the required format (it's Excel built-in format) – Vylix – 2017-06-03T20:17:44.260