Week of Month Calc

[John Wallace]

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?

[ESpringer]

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...

[Lee Smith]

Hi John,

Take a look at this discussion:

Click Here

HTH

Lee

[John Wallace]

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