How do I get my date to look like this in Excel (Monday June 19,.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to display both the Day in text and the date in serial numbers. How do
I do that?
 
I hope you don't mean serial numbers (!) - format, cells

set the format to custom as

dddd mmm dd yyyy
 
or use the same code in the text function, e.g:

TEXT(A1,"Dddd Mmm dd yyyy")
 
Right-click on the cell with the date, then FormatCells > NumberTab > Custom
and in the Type: window, dddd m/d/yyyy > ok
Click to expand...

Vaya con Dios,
Chuck, CABGx3
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need formula to return next Monday's date 4
Countif Function?? 3
Can some one modify the thirdfriday code to get me the following d 2
MX-19 a decent Windows 7 replacement. 2
setting the date to monday 2
How do I get a new calculated date from different date ranges? 3
Sorting Dates in format "01/19/09" 8
Calculate number of Mondays betweeb 2 dates 6

Back
Top