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