PC Review


Reply
Thread Tools Rate Thread

Calculating number of weeks between dates?

 
 
John
Guest
Posts: n/a
 
      29th Nov 2007
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


 
Reply With Quote
 
 
 
 
Peo Sjoblom
Guest
Posts: n/a
 
      30th Nov 2007
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
>
>



 
Reply With Quote
 
Teethless mama
Guest
Posts: n/a
 
      30th Nov 2007
=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
>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:52 AM.