To find out no of weeks in a month

Hi ,

Is there any vb function or any logic To find out no of weeks in a month.I/p is Month name

Thankx
Murali

I haven't tested it but you could try this;

StartOfMonth="01/02/2000"
NoOfWeeks = Datediff("ww",StartOfMonth,DateAdd("m",1,StartOfMonth))



------------------
Mark "Buzby" Beeton
VB Developer
[email protected]

Hi Buzby
Thanks it is working fine
Regards
Murali