Day of week and date in same cell, autofill rest of month?

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,
Is it possible to put day of week and date in the same cell in Excel 2004, and then autofill down for the rest of the month? I have tried entering a day and date in Custom, as dddd m/d....but the following is what happens (please see below). Is there a way to autofill correctly? Thank you.

Example of what happens now:
Wednesday 4/1
Wednesday 4/2
Wednesday 4/3
Wednesday 4/4
Wednesday 4/5
Wednesday 4/6
Wednesday 4/7



1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
type a date in a cell according to regional convention(either m/d/yy or d/m/yy).see control panel-region and language-short date.

Then click format-date
there is one format day, date

take the cursor to the bottom right when cursor turns to black plus sig. click this plus sign and drag the mouse down.

you get something like this


Wednesday, March 25, 2015
Thursday, March 26, 2015
Friday, March 27, 2015
Saturday, March 28, 2015