software

There are examples in the Help but none works.
I should be able to do =text(A3, quot;dddquot;) or =text(A3, quot;ddddquot;) : 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.

Your quot;datequot; 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

quot;pierrebourgaultquot; gt; wrote in
message ...
gt; There are examples in the Help but none works.
gt; I should be able to do =text(A3, quot;dddquot;) or =text(A3, quot;ddddquot;) : I get an
gt; error message saying that the formula has error. Obviously there is no
gt; indication what the error is.
gt;
gt; I am using Excel 2003.
gt;
gt; Thanks.
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.You can just use the Format Cells command, choose NUmber then Custom and set
to dddd or ddd as required.

quot;pierrebourgaultquot; wrote:

gt; There are examples in the Help but none works.
gt; I should be able to do =text(A3, quot;dddquot;) or =text(A3, quot;ddddquot;) : I get an
gt; error message saying that the formula has error. Obviously there is no
gt; indication what the error is.
gt;
gt; I am using Excel 2003.
gt;
gt; Thanks.