"Dave Peterson" wrote in message
If I were using VBA...

Take a look at Dick Kusleika's site:
http://www.dailydoseofexcel.com/arch...rmulas-in-vba/

It's a technique to workaround that .formulaarray length limit.

I forgot about that, yes a cunning trick (also a clever calendar formula in
the demo)

"Dave sent me a solution to this problem that's shown below."
Don't suppose you know which "Dave" ...?

Regards,
Peter T