source of good vba examples for newbie
 

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

source of good vba examples for newbie
 

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

source of good vba examples for newbie
 

Sunil,

I believe this is the most current FAQ:

http://www.cpearson.com/excel/newposte.htm

hth,

Doug

"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

source of good vba examples for newbie
 

Hi Sunil,

source of good vba examples for newbie

Is there a faq for this newsgroup- how to acess ?

Doug Glancy has already directed you to Chip Pearson's invaluable site, but
you may care to visit the following links too:

http://www.contextures.com/xlfaqMac.html



http://www.j-walk.com/ss/excel/faqs/xl97faq.htm



http://www.j-walk.com/ss/help/index.htm



http://www.mvps.org/dmcritchie/excel/excel.htm

---
Regards,
Norman



"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