I am trying to create a formula which will check a range of cells and if any of the dates are in a certain year I need them to be counted. The cells I am looking at though contain a formual themselves, I am not sure if this is an issue.

What I need is to know how many things will expire this year.

Column A is my employee and column B, C, D etc. is their expiry dates (for training, not for them) so I want to calculate how many certificates for one particular column will expire.

Hope this makes sense