Hi,

First date in a1
later date in a2
Try
=SUM(IF(WEEKDAY(A1-1+ROW(INDIRECT("1:"&TRUNC(A2-A1)+1)))=2,1,0))

the =2 bit is for monday change to =1 for Sundaye etc
It's an array so commit with CTRL+Shift + Enter not just enter

Mike

" wrote:

I am looking for a formula that will calculate the number of Mondays
between 2 given dates (date will always be the 23rd of the month).

I am currently using =INT((D1-WEEKDAY(D1-1)-C1+8)/7)

This is working fine up until it hits a date where the 23rd falls on a
Monday.

e.g. 23rd Sept 23rd Oct 2008 = 4 Mondays (correct)
23rd Oct 23rd Nov 2008 = 4 Mondays (correct)
23rd Nov 23rd Dec 2008 = 5 Mondays (correct)

and so on

But when I get to 23rd Jan to 23rd Feb 2009 (which falls on a Monday),
Excel is returning 5. I am wanting to see 4 at this point, same for
23rd Feb to 23rd March.

How can I amend this formula?
23rd Sept 23rd Oct 2008 = 4 Mondays (correct)
23rd Sept 23rd Oct 2008 = 4 Mondays (correct)