Joe Conner wrote:
If I put a date in cell A1, then using the calc function =WEEKDAY(A1)
I get the day number as expected. But, I would prefer to get the
day display as (Sunday, Monday, whatever).
I have not found any built-in CALC function to convert to this display.
I could build a long complicated IF function to do this, but if it does
already have such a format I want to use it.
Any advise or solution?
Just for display, or do you need the text for something else?
Use the Format code "NNN" to get the Full day of the week, "NN" for the
abbreviation, and "NNNN" to get the full name plus ", ".
-Thomas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
