No the day is not wrong, formatting only changes the display, then
underlying value of for instance Oct 22 2007 will always be

39377


and TEXT(39377,"dddd") will always return "Monday"


--


Regards,


Peo Sjoblom


"Dave" wrote in message
...
thats what i already said, but my dates are in the format mm-dd-yyyy so
the
day appears wrong.

dave

"Kevin B" wrote:

You can use this conversion formula to get the day of the week:

=TEXT(A1,"dddd")

Change cell address as needed.
--
Kevin Backmann


"Dave" wrote:

Hi Guys,

I'm looking to display the weekday in a cell, based on the date in cell
A1.

I know the code I can use is


Code:
=TEXT(A1,"DDDD")
The problem I have is my dates are formatted as MM-DD-YYYY and I cannot
change this.

How can I amend the workday formula to represet and allow for this.

Thanks
Dave