# Week of Month Calc

This topic is 7542 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

I need to calculate the week of the month for a date. For the purposes of this post, weeks are Sunday thru Saturday. November 1 is a Saturday and would be in Week 1. Nov. 2 is Sunday and would be in Week 2. Nov 3 is Monday and would be in Week 2. Nov 30 is a Sunday and would be in Week 6.

How do I calculate on the fly the Week of the month for any given date?

##### Share on other sites

Use the WeekofYear for your record's main date, and the WeekofYear for the first day of that month (which is day(Date)-Day+1)...

Something like:

WeekofYear(date)-(WeekofYear(date-(Day(date))+1))+1

The +1 thing is necessary because subtracting the day# from any date would get you one day too far back. Same with subtracting the week number of the first of the month from the week number of your date in question...

##### Share on other sites

Hi John,

Take a look at this discussion:

HTH

Lee

##### Share on other sites

Hi guys, thanks for the input.

I knew I could count on this bunch.

Strange though, I did a search for "week of month" and found no posts about it.

Best regards,

John

##### Share on other sites

This topic is 7542 days old. Please don't post here. Open a new topic instead.

## Create an account

Register a new account