Forum Discussion
Solved
Insert name of weekday beside date?
Okay, so I'm an Excel newbie who's been tasked with creating a fairly basic spreadsheet to organize some programs that my student center is holding. So my question is, if I were to input the date in ...
Hi Erin,
Select your cell(s), Ctrl+1 and apply custom format like
There's also a built in date format that will spell it out like Monday, August 27, 2018 if you enter 8/27/2018. You can highlight the cells to be formatted, then select Long Date from the number section of the ribbon. If you prefer the format previously mentioned, but decide you would rather have it display just Mon, instead of Monday, you can use ddd instead of dddd.
Bob, Long Date depends on how did you setup long date format in Windows settings. For example, my setting for long date is like July 20, 2018 and for short date 2018-07-20.
Custom format is independent on Windows settings.