I need a formula that will count all the instances of a date in a column that
are less then 30 days old. I tried a few different formulas to no avail. This
is what I currrently have that doesnt work:

=COUNTIF(Sheet2!E:E," 30 (sum(TODAY()-Sheet2!E:E))")

I could do this via VBA macro, but Im tryin to avoid that. Thanks for any
info.