Counting number of dates in a column earlier than today

D

dnmnas

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
equal to the current date or the date has passed.

Any suggestion will be greatly appreciated
 
M

mzehr

Hi,
Try
=COUNTIF(G:G,"<="&TODAY())
Will return the number of dates in column G that are =< today
 
Top