excel today countif over expired date

J

JonnieP

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 5
Excel 2010 countifs for date range 3
COUNTIF for date and amount 1
count if gone past today 2
Can i use a reference inside Countif 1
Expiry dates query 1
Formula for Dates and CF Colour then convert to Text 3
Countif with Dynamic date ranges. 2

Top