| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
=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. |
|
#3
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| search for latest date | Excel Worksheet Functions | |||
| Counting nonblank and non white space cells | Excel Worksheet Functions | |||
| Min/Max formulas using cells with date format | Excel Worksheet Functions | |||
| Format cells as date | Excel Discussion (Misc queries) | |||
| Calculating current age from 2 date cells | Excel Worksheet Functions | |||
Hybrid Mode
