Forum Discussion

mikeuk's avatar
mikeuk
Copper Contributor
Apr 18, 2020

Help!! ** How to use Countif to count dates that occur today and before?

Hi All,    Please Help,    I need to be able to count the amount of dates in a column that occur today and then also count the amount between today and in the past by number of days (not date). ...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 18, 2020

mikeuk 

Mike,

 

That's like

=COUNTIF(A:A,TODAY())

and

=COUNTIFS(A:A,"<"&TODAY(),A:A,">="&(TODAY()-30))

Resources