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

How to automate update on weekly reports spreadsheet 0
Weekly Report 2
Display weeks from a Milestone 0
HOW TO INPUT MONTHLY ACCUMULATED SALARY IN MS PROJECT? 0
Show week number in Project Report 0
Resource name inside resource sheet: per person, work per hours per week 0
Integrating information from Word to Excel (not mail merge) 1
Excel file won't save to iCloud on Mac 0

Top