weeknum of the month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi I am Tanuja i need to know what week is it in a month not in a year is it
possible
 
Assuming that the date is in A1, and week 1 starts on the 1st (not 1st
Sun/Mon say), then

=INT(DAY(A1)/7)+1

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

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

Excel conditional formatting with Weeknum 4
Weeknum(today()) gives wrong weeknummer 5
Weeknum formula 2
Inverse to WEEKNUM 8
Excel Vba to change displayed year automatically. 14
Sum daily sales by week 3
WEEKNUM function not working 4
Weeknum function help 1

Back
Top