Team,

I am searching through to get the excel formula to calculate the WeekNumber for each month beginning to end date. Week beginning day would be Monday and ending would be Sunday.

The Requirement is

Jul-2014 - Weeknumber for each date beginning from 01-Jul-2014 to 31-Jul-2014 (01-Jul-2014 to 06-Jul-2014 - Week1 and 07-Jul-2014 to 13-Jul-2014 - Week2 so on)
similarly
Aug-2014 -Weeknumber for each date beginning from 01-Jul-2014 to 31-Jul-2014 (01-Aug-2014 to 03-Aug-2014 - Week1 and 04-Aug-2014 to 10-Aug-2014 - Week2 so on)

Challenging part is i have the Date range starting from 01-Jul-2014 and go on forever.