Thomas Dodd wrote:
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
Thank you. This is exactly what I was looking for.
I wish that the help for WEEKDAY included this information.
Also, I wish that the cell format date drop-down had these choices.
Joe
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
