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

Closed
zinnia - 24 Mar 2015 à 12:51
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 24 Mar 2015 à 12:57
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?



Related:

1 response

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
24 Mar 2015 à 12:57
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