• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Count week in a month repetition

stormania

stormania

Member
Dear
Kindly help how to count a week in amonth start only 1 - 4 week. Example in june..date 1-5 june is week 1, 6-12 june is week 2, date 13-19 week 3, 20 -29 week 4, date 30 june only M1 (text).
In july...week repeat to 1 again..example date 1-10 july week 1, date 11-17 week 2, 18-24 week 3, 25-29 week 4, date 30 is M1. Even in august week repaeat 1 again .
Kindly help

Thank you
 
Please help to understand,
why
June week 1 have 5 days?
July week 1 have 10 days?

try below formula -

=WEEKNUM(A1)-WEEKNUM(A1-DAY(A1)-7)

stormania said:
Dear
Kindly help how to count a week in amonth start only 1 - 4 week. Example in june..date 1-5 june is week 1, 6-12 june is week 2, date 13-19 week 3, 20 -29 week 4, date 30 june only M1 (text).
In july...week repeat to 1 again..example date 1-10 july week 1, date 11-17 week 2, 18-24 week 3, 25-29 week 4, date 30 is M1. Even in august week repaeat 1 again .
Kindly help

Thank you
Click to expand...
 
Hi ,

To add to what has already been posted , what is the meaning of July 30 is M1 ? July has 31 days. What about July 31 ?

Narayan
 
You must log in or register to reply here.
Back
Top