Calculating number of weeks between dates?

's Computer Specifications

Hi. Does anyone know how I can calculate the number of whole weeks
between two dates?

E.g. I have 09/07/2007 in cell B10.
In cell B11 01/12/2007.

Is there a formula I can use to calculate the number of saturdays
between those two dates?

If I do B11-B10 I get the result 22/05/1900.

Cheers for your help

John

's Computer Specifications

One way

=SUM(INT((WEEKDAY(B10-7)+B11-B10)/7))

--

Regards,

Peo Sjoblom

"John" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi. Does anyone know how I can calculate the number of whole weeks
> between two dates?
>
> E.g. I have 09/07/2007 in cell B10.
> In cell B11 01/12/2007.
>
> Is there a formula I can use to calculate the number of saturdays
> between those two dates?
>
> If I do B11-B10 I get the result 22/05/1900.
>
> Cheers for your help
>
> John
>
>

's Computer Specifications

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(B10&":"&B11)))=7))

"John" wrote:

> Hi. Does anyone know how I can calculate the number of whole weeks
> between two dates?
>
> E.g. I have 09/07/2007 in cell B10.
> In cell B11 01/12/2007.
>
> Is there a formula I can use to calculate the number of saturdays
> between those two dates?
>
> If I do B11-B10 I get the result 22/05/1900.
>
> Cheers for your help
>
> John
>
>
>

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
calculating number of weeks between two set dates	=?Utf-8?B?YW5zd2VyNzg2?=	Microsoft Excel Worksheet Functions	2	21st Aug 2007 04:34 PM
calculating number of weeks between two dates	=?Utf-8?B?dm5zcm9kMjAwMA==?=	Microsoft Excel Worksheet Functions	4	28th Mar 2007 08:34 PM
Calculating number of weeks between dates (start and end dates)	=?Utf-8?B?R2VyYWxkIExlbWF5?=	Microsoft Excel Discussion	1	28th Mar 2007 01:13 PM
Calculating number of weeks from two dates	spudgun	Microsoft Excel Misc	5	4th Aug 2005 12:08 AM
calculating (correctly) the weeks and days between dates	neon	Microsoft Excel Worksheet Functions	4	28th Jun 2004 03:07 PM