counting specified date entries

D

dave

Hi,
Please can someone advise me on the formula I require for this problem.

I would like to calculate the number of dates in a specified column, that is
equal to the current date or the date has passed.

Any suggestion will be greatly appreciated
 
A

Aladin Akyurek

=COUNTIF($A$2:$A$15,"<="&F2)

would count dates in A2:A15 less than or equal to the date in F2, wit
which they are compared.
 
D

dave

Many Thanks

Aladin Akyurek said:
=COUNTIF($A$2:$A$15,"<="&F2)

would count dates in A2:A15 less than or equal to the date in F2, with
which they are compared.
Click to expand...
 

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

Space at end of multi page list to accommodate new entries 1
Display weeks from a Milestone 0
Copy previous record into form field 0
Email notifications without opening application 1
Calculate the median value before a specified list 0
Count partial dates 1
Using <= in countifs statement 1
Problem with formula for finding last greater than/less than or equal to value 2

Top