Hi,

I have an excel sheet which contains huge data, almost 60k rows, I want to count that how many rows are in 2014.

E.g. March- 04, 2014. June 16, 2015.

Due to some reason I don't want to sort the dates nor apply filters. I thought of combining countif with right formula but didn't get the desired result.

Can any one help me here