How do I get a cell to show the day of the week when date entered

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

Guest

How do I get a cell to show the day of the week when date entered.
Example:A1 = 01/02/2005, A2 should Show Monday or MON.
I have Excel 2000.
 
Try this:

Select the cell(s) that are impacted
Format>Cells>Number tab
Category: Custom

Type: ddd
Returns: Mon, Tue, etc

Type: dddd
Returns: Monday, Tuesday, etc

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Hi Captn'

Try =TEXT(A1,"ddd") which will return SUN, not MON for 1/2/2005


HTH
Regards,
Howard
 
Captain said:
How do I get a cell to show the day of the week when date entered.
Example:A1 = 01/02/2005, A2 should Show Monday or MON.
I have Excel 2000.
Click to expand...

Thanks! Is there a way to get the week # for a specific date?
 
L. Howard Kittle said:
Hi Captn'

Try =TEXT(A1,"ddd") which will return SUN, not MON for 1/2/2005


HTH
Regards,
Howard



Thanks!
How do I get a cell to show the Week Number for specific dates?
Click to expand...
Thanks again
Captain
 
Unless the Captain is English, then it would return TUE

<bg>

--
Regards,

Peo Sjoblom

(No private emails please)
 

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

Day of the week and date 3
number of days in week issue. 9
Format cells to show dates as the day of the week 3
Automatically update a cell with a date based on anther cells date 2
Week Number Format 4
Name of the Day 2
Dates and days of the week 3
Summing rows based upon condition 2

Back
Top