Works like a champ...thx!!
"Bob Phillips" wrote:
=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.
|