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.