OSCAR TORRES

Oscar Torres

I am trying to count to amount of cells that have a date within the next 30 days,

Any help will be highly appreciated

Heather Duff

Hi @Oscar Torres ,

Try this:

=COUNTIFS([due date]5:[due date]8, >=TODAY(),[due date]5:[due date]8, <=TODAY(30))

Let me know if it works for you.

Best,

Heather