Question description:
This user has given permission to use the problem statement for this
blog.
Hi there! what format do I put in cell if I want it to say day as well as month-day-year
Solved by Z. B. in 25 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
16/10/2018 - 02:49
Hi
Excelchat Expert
16/10/2018 - 02:49
Welcome to got it Pro
Excelchat Expert
16/10/2018 - 02:49
Before we get started, this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows.
Excelchat Expert
16/10/2018 - 02:50
Please tell a bit more about the requirement so that i can help better
Excelchat Expert
16/10/2018 - 02:50
See cell C1
Excelchat Expert
16/10/2018 - 02:51
just wrote the formula =today()
Excelchat Expert
16/10/2018 - 02:51
it by default gives us month/date/year
Excelchat Expert
16/10/2018 - 02:51
Are you there?
Excelchat Expert
16/10/2018 - 02:52
Please say something
Excelchat Expert
16/10/2018 - 02:52
There is also custom format from where you can change date format
Excelchat Expert
16/10/2018 - 02:52
Are you there?
User
16/10/2018 - 02:53
Hi Sorry
User
16/10/2018 - 02:53
I would like to add the day...so I would want it to say Tuesday, October 16, 2018
Excelchat Expert
16/10/2018 - 02:54
See now
User
16/10/2018 - 02:54
What did you do?
Excelchat Expert
16/10/2018 - 02:54
It is there in custom format
Excelchat Expert
16/10/2018 - 02:54
on top there is format in spreadsheet
User
16/10/2018 - 02:55
ok let me try
Excelchat Expert
16/10/2018 - 02:55
click on number and go to more date and time formats
Excelchat Expert
16/10/2018 - 02:55
in excel it would be little different than this spreadsheet
User
16/10/2018 - 02:56
ya so I don't have a format tab
Excelchat Expert
16/10/2018 - 02:56
in excel it is in home tab
Excelchat Expert
16/10/2018 - 02:56
where general is written
Excelchat Expert
16/10/2018 - 02:56
open that
User
16/10/2018 - 02:57
sorry don't understand
User
16/10/2018 - 02:57
in home tab
User
16/10/2018 - 02:57
I type in =today()
User
16/10/2018 - 02:57
what is custom format
User
16/10/2018 - 02:57
can you show me
User
16/10/2018 - 02:57
pls
Excelchat Expert
16/10/2018 - 02:58
See this
[Uploaded an Excel file]
User
16/10/2018 - 02:58
doesn't work
Excelchat Expert
16/10/2018 - 02:58
just beside conditional formatting there is dropdown
User
16/10/2018 - 02:58
I have to run to a meeting
Excelchat Expert
16/10/2018 - 02:58
open that
Excelchat Expert
16/10/2018 - 02:59
then click on more number format
User
16/10/2018 - 02:59
I opened format
Excelchat Expert
16/10/2018 - 02:59
and select date
User
16/10/2018 - 02:59
ya
Excelchat Expert
16/10/2018 - 02:59
and then select format with day of week as well
User
16/10/2018 - 02:59
I don't see that option
User
16/10/2018 - 03:00
gotta run
User
16/10/2018 - 03:00
don't see day of week as option
Excelchat Expert
16/10/2018 - 03:00
See this
[Uploaded an Excel file]
Excelchat Expert
16/10/2018 - 03:00
this shows the option you want
Excelchat Expert
16/10/2018 - 03:01
Does it help?
Excelchat Expert
16/10/2018 - 03:01
please let me know
Excelchat Expert
16/10/2018 - 03:14
Please do give good rating and reviews. It really helps.
Excelchat Expert
16/10/2018 - 03:14
Take Care
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.
