ExcelBanter - Counting date cells...

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Counting date cells... (https://www.excelbanter.com/excel-worksheet-functions/39742-counting-date-cells.html)

Dave Schwinger

Counting date cells...

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.

Bob Phillips

=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.

Dave Schwinger

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.

All times are GMT +1. The time now is 05:45 AM.