Isn't it amazing how some threads deal with "complicated" solutions and
generate some really top notch contributions yet the OP is nowhere in sight!

Biff

"Ron Rosenfeld" wrote in message
...
On 15 Jun 2005 11:46:12 -0700, "Harlan Grove" wrote:

An opportunity to simplify the formula. Now not even an array formula.

=SUMPRODUCT((DAY(ROW(INDIRECT(StartDate&":"&EndD ate)))={1,16,16,16,16})
*(DAY(ROW(INDIRECT(StartDate&":"&EndDate))+{0,13 ,14,15,16})=1)
*(ROW(INDIRECT(StartDate&":"&EndDate))+{14,12,13 ,14,15}<=EndDate))

Very nice!


--ron