Try this:
A2: =A1
FormatCellsNumber tab
Category: Custom
Type: ddd

Returns Mon, Tue, Wed, etc.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Neil M" wrote:

Is there an formula to automatically display the "day of the week" in cell A2
based on a date entered in cell A1? I have one now but it is very long and am
trying to shorten it.

NeilM