The WEEKDAY( ) function returns a number relating to the day of the
week - you could then turn this number into the name of the day using
something like CHOOSE, or LOOKUP.

However, an easier way is to put this formula in B1:

=A1

and format B1 using Custom to "dddd". Alternatively, use a custom
format on cell A1 as "dddd, mmm dd yyyy" to save using another column.

Hope this helps.

Pete

On Mar 16, 9:19 pm, Ajay wrote:
Hi,
Can someone tell me how to use WEEKDAY function??.

Ex:
Imagine A1 has March 17th 2007

The formula should finally say that A1 is "Sunday"

Pls let me know.
--Ajay--