Count how many cells is before a date

[stan255]

Hi,

excel-question-3.png

How can you count how many cells has the date before a certain date?

Using the example above, how can we count the number of cells in column B with a date after 30/01/2017

Any help or suggestions would be greatly appreciated.

Cheers.
Stan

[Tony Valko]

Use a cell to hold the date criteria:

D2 = 30/01/2017

Then:

=COUNTIF(B2:B50,">"&D2)

[stan255]

Thanks Tony, that worked!
+rep

[Tony Valko]

You're welcome. Thanks for the feedback!