excel today countif over expired date

G

Guest

Hi

I use a large SS that has expiry dates in column H for "live" jobs. I have a
stats screen that counts the amount of entries that are beyond this date
using a countif statement. For example: =countif('Sheetname'!H:H,today())-1)

I repeat this upto -7 and that is excels limit on the amount of statements I
can perform. So, I can only see the amount of jobs that are a max of 7 days
over the expiry. Im sure there is an easier calculation for this that will
count more than 7 days past today?

Please help!!!

John
 
R

Roger Govier

See reply to your question posted in .misc
Please post to one group only to prevent wasting peoples time answering
posts already replied to.

Regards

Roger Govier
 

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

Count if past today () - 30 days 4
count if gone past today 2
Excel Formula - Count Dates from another Sheet 8
Countif with Dynamic date ranges. 2
Countif if counted results are based on formula 6
countif where condition should be met 3
COUNTIF, only counting once if both cells contain the data 4
Count Days more than 180 days prior to today 4

Top