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

Report
-
venkat1926
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
790
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