<div>
I would put the date &nbsp;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<br />
<br />
=COUNTIF(A3:A11,&quot;&gt;&quot;&amp; A1)<br />
<br />
You can put the date into the formula but my suggestion is more flexible.
</div>


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.

Analyst

Asatoma Sadgamaya

<div>
Thanks subodh. That did work for me
</div>


<div>
My formula is the same but different ranges!
</div>


My formula is the same but different ranges!

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
How can i count number of dates greater than a given date in excel, using excel function(countif)?<br />
<br />
Thank you
</div>
</div>


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

Number of dates greater than a given date

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.