I all you want is the day of the week, this will do the trick...

=CHOOSE(MOD(DateValue,7),"Sun","Mon","Tue","Wed"," Thurs","Fri","Sat")

So, if your date is in A1 the formula would be entered as:

=CHOOSE(MOD(A1,7),"Sun","Mon","Tue","Wed","Thurs", "Fri","Sat")
--
Kevin Backmann


"Pete" wrote:

You could just format the cell containing the date using custom set to
dddd. If you want to see the day and the date, you could custom format
the cell as dddd, dd/mm/yyyy (UK format).

Alternatively, if you want to show the day in a separate cell and your
date is in A1, enter this formula in cell B1:

=WEEKDAY(A1)

and format this cell as custom dddd.

Hope this helps.

Pete