Here's an alternative:

You only need to test for the year:

=SUMPRODUCT(--(YEAR(FM!J$3:J$5403)=2004))

Biff

"S Davis" wrote in message
ups.com...
Step three (counting dates between ranges) works by using:

=SUMPRODUCT(--(FM!J$3:J$5403$E$1),--(FM!J$3:J$5403<=$G$1))

... where E1 and G1 are the date "limits", respectively :)

Quite happy to have this finished! Hopefully this can help someone in
the future.