Determining number of weeks in a month

C

Cameron

How would i determine how many weeks in a current month? And how many days in
the current month.
 
J

John W. Vinson

How would i determine how many weeks in a current month? And how many days in
the current month.

The latter is easy: Day(DateSerial(Year(Date()), Month(Date()) + 1, 0))

Weeks is a bit ambiguous. Do you want to full weeks? At least three days to
count as a week? Any weekday counts as a week? If a month starts on Friday the
1st and ends on Sunday the 31st (e.g. August 2008) is that six weeks? What's
your definition of "the number of weeks" in other words?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top