Day of week and date in the same cell, then autofill rest of mon

[Closed]
Report
-
Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
-
Hello,

I would like to know how to put the weekday and date into one cell, as in: Wednesday, 4/1.

Then I want autofill to fill the rest of the month down in the same format. Is this possible?



1 reply

Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
486
Hi Zinnia,

This can be done by formatting your cells.

Select your cells and go to cell properties (Ctrl + 1) > Numbers tab > Custom.
Then enter the following string:
dddd m/d

Best regards,
Trowa