Display weekday when date is MM-DD-YYYY

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You can use this conversion formula to get the day of the week:

=TEXT(A1,"dddd")

Change cell address as needed.
 
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
 
thats what i already said, but my dates are in the format mm-dd-yyyy so the
day appears wrong.

dave
 
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
 
Back
Top