Hi,

I have a column full of dates in the dd/mm/yyyy format. Now I am trying to count how many entries with specific dates exist in this column, however, the date i want to count, is defined by another cell's value.

Example:
A1 = 2012
A2 = Jan
A3 = 01

I need the formula to count how many entries exist for 01/01/2012 but need to have the DD, MM, YYYY pulled from these cells.

Any suggestions?

Thanks,
A2k