Count Dates Greater Than

[ARJUNDSOUZA]

Dear Gurus,

I am looking for a formula (E2) which can count the number of cells which has a ">=D2" from the range $B$2:$B$273, the same formula then continues into cell E3,E4,E5.... while criteria will be cells D3, D4,D5...

As the list is updated often and then a graph is related to it, I wanted to insert the formula to calculate and graph would update accordingly (have got the graph ready).

Thanks in advance,

Kind regards
Arjun

 

[AlanSidman]

In E2 =COUNTIF($B$2:$B$273,">="&D2) and copy down

 

[ARJUNDSOUZA]

Thank you @AlanSidman, this works perfectly.

 

[Peter Bartholomew]

As a Microsoft 365 use I have the option of entering a dynamic array formula in cell E2
= COUNTIFS(date, ">="&months)
The only difference is that one formula returns the entire array.
['date' and 'months' are defined names that return the data columns]

 

[ARJUNDSOUZA]

Thank you @Peter Bartholomew for the new formula, as I am using Office 2013 version currently... will keep the formula on file for future reference.

 

[Rickbale]

To count numbers or dates that meet a single condition (such as equal to, greater than, less than, greater than or equal to, or less than or equal to), use the COUNTIF function.

Regards,
Rick Bale