Display weekday when date is MM-DD-YYYY - Dav

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

Display weekday when date is MM-DD-YYYY - kbackman

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

=TEXT(A1,"dddd")

Change cell address as needed.
--
Kevin Backmann

Display weekday when date is MM-DD-YYYY - Peo Sjoblom

Excel dates regardless of formatting are days since Jan 0 1900 so if you are
using a different format
it doesn't make any difference as long as you are using what Excel
interprets as dates
If you don't the weekday using that formula then your dates are text strings
and you need to make sure they are numerical by entering them according to
your regional settings in your OS and then  use a custom format


--


Regards,


Peo Sjoblom

Display weekday when date is MM-DD-YYYY - Dav

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

dave

Display weekday when date is MM-DD-YYYY - Peo Sjoblom

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