Hi,

I've got a list of around 300 dates Format e.g 01/07/2006 for different years. Also some entries have ' in front of them to make them text

I want to count the number of dates in say A2 to A300 (may have blanks) and then count the how many in current year 2006.

Would like it to return something like "There are 200 entries in current year out of 299".

Thanks in advance

VBA Noob