| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
