On sheet 1 I have the months across the top row and lets say that the month
of March is in c1. On sheet 2 I have a column (d1:d20) with many dates, and
I want to count the number of dates in the month of March.
I think it would go something like this,
=countif(month(sheet 2(d1:d20)),sheet 1(c1))
I may not have all of the () in the right place but hope you get the idea.
Thansk