Hi!

Actually, I've thought about the June 5 2079 row limitation many times but I
personally have never had to come up a formula that projects that far into
the future so I never bothered looking into a fix.

Maybe in one of the future versions of Excel MS will increase the number of
rows and solve that limitation for us!

Cheers

Biff

wrote in message
...
Biff
I like the use of the Row() function as you have used it in array
formulas.
However, and risking looking a bit picky...<g
when used in dates we have an iminent Y2K situation on the 5 June 2079.
(the date value of the last row)

A small fix you could employ
SUMPRODUCT(--(WEEKDAY(A1-1+ROW(INDIRECT("1:"&B1-A1)),2)={1,2}))
or in your final formula

=IF(COUNT(N3:O3)<2,"",SUMPRODUCT(--(WEEKDAY(N3-1+ROW(INDIRECT("1:"&O3-N3)),2)=MATCH(G3:I3,{"M","T","W","TH","F","SA","SU ",0},0))))

just using the Row() to increment the date not be the date.

This is still not perfect as you can only have dates approx 179 years
apart.

hope it's of interest
RES