Saturday??????

If A1 contains the date (not 17th), you could just format the cell:

Format|Cells|number tab|Custom category
dddd

If you wanted to use another cell to return Saturday, you could use:
=a1
and format it as dddd
or
=text(a1,"dddd")



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--

--

Dave Peterson