Determining number of weeks in a month

's Computer Specifications

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

's Computer Specifications

On Tue, 14 Oct 2008 13:32:00 -0700, Cameron
<(E-Mail Removed)> wrote:

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

John W. Vinson [MVP]

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do you calculate the number of weeks on a month	=?Utf-8?B?U3Vubnlza2llcw==?=	Microsoft Excel Misc	6	22nd Nov 2007 10:54 AM
Number of weeks in month view	=?Utf-8?B?RnJlZCBN?=	Microsoft Outlook Calendar	1	5th Sep 2007 10:07 PM
Find Number of Weeks in a Month	=?Utf-8?B?U0w=?=	Microsoft Excel Programming	6	17th Jul 2007 12:48 AM
How do I count the number of even weeks in the current month.	dd	Microsoft Excel Worksheet Functions	6	22nd Feb 2007 07:29 AM
Determining number of weeks between dates	goonboy175	Microsoft Excel Discussion	1	18th Jul 2005 09:17 PM