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

Closed
zinnia - Mar 24, 2015 at 04:49 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Mar 25, 2015 at 05:59 AM
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



Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Mar 25, 2015 at 05:59 AM
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
0