Question description:
This user has given permission to use the problem statement for this blog.
I am needing to place the name of a day next to column of date to determine preferred booking options...
Solved by G. J. in 6 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert
01/09/2018 - 05:57
Hello! How are you?
User
01/09/2018 - 05:57
Well thank you
User
01/09/2018 - 05:57
How are you today?
Excelchat Expert
01/09/2018 - 05:57
That's great.
Excelchat Expert
01/09/2018 - 05:57
I'm a well. Thanks for asking :)
User
01/09/2018 - 05:57
:)
Excelchat Expert
01/09/2018 - 05:57
Anyway, you need help to return the name of the day for a cell next to a date right?
User
01/09/2018 - 05:58
yes please
Excelchat Expert
01/09/2018 - 05:58
Okay - i can show you how it is done in the document preview to the right
User
01/09/2018 - 05:58
Super
Excelchat Expert
01/09/2018 - 05:59
Basically the formula is TEXT(reference cell,"dddd")
Excelchat Expert
01/09/2018 - 05:59
or you can use "ddd" instead for shortened name of the days
User
01/09/2018 - 05:59
Oh that's great...
Excelchat Expert
01/09/2018 - 06:00
i.e., instead of Monday > Mon, Tuesday > Tue, etc.
Excelchat Expert
01/09/2018 - 06:00
Could you please confirm if that works for you?
User
01/09/2018 - 06:00
sure...
User
01/09/2018 - 06:01
That's Perfect!
User
01/09/2018 - 06:01
Thank you for your help!
Excelchat Expert
01/09/2018 - 06:01
Happy to hear that
Excelchat Expert
01/09/2018 - 06:02
Any more clarifications?
User
01/09/2018 - 06:02
No not today - I wish had more questions :)
Excelchat Expert
01/09/2018 - 06:02
If not - you may end the session any time now by clicking the END SESSION button to the right of the countdown timer
Excelchat Expert
01/09/2018 - 06:02
Awesome
User
01/09/2018 - 06:02
You've been a great help with my timeframe...something simple for you I'm sure, but I just couldn't crack it!
Excelchat Expert
01/09/2018 - 06:02
Appreciate if you could leave a feedback on a survey afterwards
Excelchat Expert
01/09/2018 - 06:03
No worries at all. Happy to help
User
01/09/2018 - 06:03
Sure will
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.
