format(cdate("3/07/2005"),"dddd")

If you have a true date argument you will not need CDate()



"Sunil Patel" wrote in message
...
Hi

i am sure this has been asked a million times , but i can't find answer !!
How do you return "Sunday" from "3/07/20055" in vba.
i need a$ to = "Sunday"
Is there a faq for this newsgroup- how to acess ?

Sunil