COUNT IF A DATE IS HIGHER THAN ANOTHER DATE

M

Mally

What formula will work to total the number of dates in column B that are
greater than the date in Cell A1. In the example below the answer will be 2.

e.g.
Cell A1 = 21/4/2008

Cell B1 = 2/1/2007
Cell B2 = 22/4/2008
Cell B3 = 17/8/2008
 
M

Mally

Thanks Don, that's great.

Its the part after the cell range I couldn't figure out.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with a Date formula please? 2
Is that possible. More than on If Formula 2
How to set the function - countif? 4
Conditional Sum date range 2
Earlest Date Based On A Date Using Min Formula 5
Finding the week of date 4
autoupdate data? 4
Is that possible; More than one Formula 3

Top