Posted to microsoft.public.excel.worksheet.functions

Roger Govier[_3_] Roger Govier[_3_] is offline

external usenet poster

Posts: 2,480

Calculate number of Mondays betweeb 2 dates

Hi

Thanks guys but these still trip up when they hit the months where a
Monday is also the 23rd! Extremely annoying but as there are only a
few a year I will manually amend for these months. Cheers anyway!
these formulas are good and I am sure will come in handy.

Try
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)),2)=1))-
(WEEKDAY(A2,2)=1)

--
Regards
Roger Govier

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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 the number of a Mondays between two dates	AChua	Excel Discussion (Misc queries)	2	January 25th 08 12:53 AM
Calculate next number using dates?	cyndiwise notsowise	Excel Worksheet Functions	12	April 2nd 07 09:02 AM
How do I calculate number of Mondays in a given month in Excel?	Rossta	Excel Worksheet Functions	3	May 26th 06 04:07 PM
calculating number of days (e.g., Mondays) between two dates	girlfriend in school	Excel Worksheet Functions	10	July 14th 05 07:21 PM
number of mondays in period	nico	Excel Discussion (Misc queries)	3	June 10th 05 02:07 AM

All times are GMT +1. The time now is 08:50 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us