Highlighted
New Contributor

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

Hi All,

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).

Can you help?

Mike

3 Replies
Highlighted

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

Mike,

That's like

``=COUNTIF(A:A,TODAY())``

and

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

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

Hi Sergei,

Thank you so much for your help!

I have used the first one and it works perfectly! thank you

But, I need the second one to display the amounts of dates in total that occur before today?

Thanks

Mike

Highlighted

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

Mike, if before today

``=COUNTIFS(A:A,"<"&TODAY())``

or you need number of dates, not number of records? For example, if today is Apr 18, and you have 3 records for Apr 16 and two records for Apr 17, above formula returns 5. If calculate only dates it shall be 2, please clarify what is required.