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

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.

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

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.

--
Kind regards,

Niek Otten

"pierrebourgault" wrote in
message ...
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.

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

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.

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

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

"pierrebourgault" wrote:

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.