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


--
HTH

Bob Phillips

"Dave Schwinger" wrote in message
...
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.