how to get week number in month in excel ?

try this url
http://www.cpearson.com/excel/weeknum.htm

solutions of pracatially all problem have been solved by the MVPs. you have
only do google search.



ikin wrote in message
...
how to get week number in month in excel ?

If you mean the week within the month (i.e., week 1 always starts on
the first of a month), then use =INT((day(x)-1)/7)+1 where x is the XL
date of interest.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
how to get week number in month in excel ?