D
Dave Schwinger
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.
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.