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 ?