Number of dates greater than a given date

Asatoma Sadgamaya
Asatoma Sadgamaya used Ask the Experts™
on
Hi

How can i count number of dates greater than a given date in excel, using excel function(countif)?

Thank you
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Roy CoxGroup Finance Manager

Commented:
I would put the date  that needs to be compared in one cell then use this formula where A1 contains the date and A3:A11 is the date range to check. Obviously adjust the ranges

=COUNTIF(A3:A11,">"& A1)

You can put the date into the formula but my suggestion is more flexible.
Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
1) Say your dates are in range A2:A15 and date criteria is in B1, then try this...
The below formula will count the dates in A2:A15 which are greater than 1st September, 2018.
=COUNTIF(A2:A15,">"&B1)

Open in new window


2) Say your dates are in range A2:A15 and date criteria is hard coded i.e. not mentioned on a cell, then try this...
The below formula will count the dates in A2:A15 which are greater than 1st September, 2018.
=COUNTIF(A2:A15,">"&DATEVALUE("09/01/2018"))

Open in new window

Author

Commented:
Thanks subodh. That did work for me
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
You're welcome Asatoma!
Roy CoxGroup Finance Manager

Commented:
My formula is the same but different ranges!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial