Counting date cells...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
=COUNTIF(Sheet2!E:E,">"&(TODAY()-30))-COUNTIF(Sheet2!E:E,">="&(TODAY()))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formaula for less than date and name begins with...!!! HELP!!! 3
Excel Formula - Count Dates from another Sheet 8
subtract one cell from each cell in a range and count instances 2
How to count a coloum if two conditions are met 5
subtract a single cell from range of cells and then count 8
Countif with a Range of criteria 8
countifs criteria includes date range 4
Formulas and counting 8

Back
Top