COUNTIFs for Dates

KMan1190

I'd like to create a formula which only counts the Rows in which a date in a particular column is in the last 30 days (among other criteria)



=COUNTIFS({Referral Source}, "Elm", {Database Status}, "Green", {Database Date of Referral}, <TODAY(-30))

The section in Italics is the area I am trying to sort out.

Thanks in advance for any help.

Genevieve P.

You've almost got it! Saying "less than" 30 days ago is actually saying "before" 30 days ago, so it won't return the correct result as it will be looking for 30+ days ago. (Back in time < is less, forward in time > is more. You can read about formula operations in our Help Center).

If you're looking for a date range, you'll want to specify the start and end of that range. For example, after or equal to 30 days ago, but earlier or equal to today. Try this:

{Database Date of Referral}, >=TODAY(-30), {Database Date of Referral}, <=TODAY()

You can see my example in the screen capture below.



 

KMan1190

Thanks for the help and link to article, the formula worked-

Have a great day!

Genevieve P.

Awesome! So glad this helped.

Cheers,

Genevieve