Count how many cells is before a date

**stan255** · 01-31-2017, 08:13 PM

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** · 01-31-2017, 08:57 PM

Use a cell to hold the date criteria:

D2 = 30/01/2017

Then:

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

**stan255** · 01-31-2017, 09:16 PM

Thanks Tony, that worked!
+rep

**Tony Valko** · 01-31-2017, 09:52 PM

You're welcome. Thanks for the feedback!

Count how many cells is before a date

LinkBack

Thread Tools

Rate This Thread

Display

Count how many cells is before a date

Re: Count how many cells is before a date

Re: Count how many cells is before a date

Re: Count how many cells is before a date

Thread Information

Users Browsing this Thread

Similar Threads

Count cells with a date

[SOLVED] count occurrenced of today's date in cells where the date is imbedded in other text

[SOLVED] count cells that include a date

Need to count cells that have a certain ship date and have a receive date

Count cells between a date range

Count number of cells with date &lt;today's date

count the number of cells with a date <= today's date

Bookmarks

Bookmarks

Posting Permissions