Countif function for dates

**nitin.asalkar** · 11-22-2012, 03:00 AM

Hi,

Need help in counting number of cells (in cloumn A) having dates greater than a specific date entered into a cell (E1)
I have attached the file. The countif function is not showing 0 as result.
Regards

**FDibbins** · 11-22-2012, 03:03 AM

you were almost there...
=COUNTIF(A:A,">"&E1)

**nitin.asalkar** · 11-22-2012, 03:16 AM

Thanks a lot

**FDibbins** · 11-23-2012, 09:13 PM

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neet and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)