Posted to microsoft.public.excel.worksheet.functions

Teethless mama Teethless mama is offline

external usenet poster

Posts: 3,718

Calculating number of weeks between dates?

=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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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

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

All times are GMT +1. The time now is 05:44 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us