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

Closed

zinnia - Mar 24, 2015 at 12:51 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 24, 2015 at 12:57 PM

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?

Day of week and date in the same cell, then autofill rest of mon
Time of day clock stopped - Guide
Hay day download pc - Download - Simulation
Windows calendar show week number - Guide
Time set day - Guide
If cell contains date then return value ✓ - Excel Forum

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Mar 24, 2015 at 12:57 PM

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

Similar discussions

If cell = date return yes or no.

help me to add particular cells

If a cell contains any text then add a value

trying to have the current date go into one cell (A1)

Excel - IF function with multiple words

Similar discussions

Subscribe To Our Newsletter!