I have a spreadsheet that contains mostly dates and have worked out how to
count them!! the next issue is i have one column with text and would like to
count if in that column and then dates in a month from the next colum.

ie:

Dept Date

CON 23/01/2009
NFT 24/05/2010
CPE
EDC 08/10/2012

so that if con has 2 dates i know how many for a given month (in the future).

Hope that makes sense!! And Thanks guys