How to convert a date into the day name in Excel ?

  • Thread starter pierrebourgault
  • Start date
P

pierrebourgault

There are examples in the Help but none works.
I should be able to do =text(A3, "ddd") or =text(A3, "dddd") : I get an
error message saying that the formula has error. Obviously there is no
indication what the error is.

I am using Excel 2003.

Thanks.
 
N

Niek Otten

Your "date" is probably text. You can check with the ISNUMBER or ISTEXT
function.
Format the cell as date or number and re-enter the date. Just formatting
won't do; you need to re-enter.
 
D

Dave O

With all due respect to Niek's response, may I beg to differ? Rather
than re-enter all the dates, you may be able to parse the text entries
into Excel-recognized dates using MID, RIGHT, LEFT functions in
conjunction with MONTH, DAY, and YEAR functions.
 
S

Sheila D

You can just use the Format Cells command, choose NUmber then Custom and set
to dddd or ddd as required.
 
Top