# How many day in the last week of a month

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

## Recommended Posts

Is there a way to calc how many days are there in the last week of month by using a date field? i.e. 3/29/2004 is the forth week of the month but how many days are in that week for that month? Answer is 3.

##### Share on other sites

I'm assuming that the week starts on Sunday, not Monday.

Learn about the DayOfWeek function. It'll probably give you the answer. To find the last day of any month, calculate the first day of the next month and subtract one day.

Errr, by my calculations there are 5 weeks in February 2004, and there is 1 day in the last week. Unless I've got it wrong...

##### Share on other sites

Thank you. I meant march, I changed by post.

##### Share on other sites

Hi tdignan,

(WeekofYear(YourDate)-WeekofYear(Date(Month(YourDate), 1,Year(YourDate)))) + 1

Lee

##### Share on other sites

Here's my calc, assuming Sunday start of week. Day of Week returns a number, 1 being Sunday, 7 being Saturday, so determine day of week of last day of month (first day of next month - 1). This number would coincidentally also be how many days in the week.

DayofWeek(Date(Month(OurDate) + 1, 1, Year(OurDate)) - 1)

##### Share on other sites

Or:

DayofWeek( Date(Month(OurDate) + 1, 0, Year(OurDate)) )

Day zero of any month is the last day of the prior month.

##### Share on other sites

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

## Create an account

Register a new account