how to get week number in month in excel ?

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Back
Top