how to get week number in month in excel ?

T

Tushar Mehta

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Week number into Month 5
Convert Week number to Month 0
Chart displaying weekly data group in months without weekly labels 7
Red cell for negative numbers in Excel 1
Bargain 30GB for £10 a month on a 1 month contract. 4
Plotting against Date (collating months) 1
Graphing weekly/monthly averages 4
Excel How to add a calendar month to and existing excel file created in a template 1

Top