About Us

John[_12_]

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

Peo Sjoblom

One way

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

--

Regards,

Peo Sjoblom

"John" wrote in message
...
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

Teethless mama

=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	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
calculating number of weeks between two dates	vnsrod2000	Excel Worksheet Functions	5	April 2nd 23 07:33 PM
calculating number of weeks between two set dates	answer786	Excel Worksheet Functions	2	August 21st 07 04:34 PM
WORK OUT NUMBER OF WEEKS BETWEEN TWO DATES	cyp010905	Excel Worksheet Functions	1	March 7th 06 04:17 PM
Calculating number of weeks from two dates	spudgun	Excel Discussion (Misc queries)	5	August 4th 05 12:08 AM
HOW TO CALCULATE NUMBER OF WEEKS BETWEEN TWO GIVEN DATES(MAY BE .	WARRENCHERYL	Excel Worksheet Functions	1	January 5th 05 08:15 AM

Menu

About Us