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 some fashion, could I get Excel to insert the corresponding day of the week beside it in the same cell? For example, if I were to input "9/17/18" into cell 2 of Column A, could I get Excel to insert the day of the week to have that cell then say something like "Friday, 9/17/18"? I'm sure this is some super easy thing, but I don't know how to do that.
Thanks in advance for your help!
Hi Erin,
Select your cell(s), Ctrl+1 and apply custom format like
4 Replies
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.
Hi Erin,
Select your cell(s), Ctrl+1 and apply custom format like
- Thank you so much!
