You could use the Text function so for example if the cell A1 contained
01/01/05 u could write =text(A1,"DDDD MMMM YYYY") and that would return
Saturday January 2005, of course instead of A1 you could have a result of a
formula or anything you wish to munipulate.
Hope that helps
__________________________
Naz
London
"abbylulu2" wrote:
I need a formula that will display a date as the day of the week, the month
and the date (example: Wednesday, January 26). I've researched all the date
functions and can't find one that returns the weekday in text, only as a
number. Can anyone help?
|