excel today countif over expired date

  • Thread starter Thread starter Guest
  • Start date Start 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
 
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
 
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

Count if past today () - 30 days 4
Excel Formula - Count Dates from another Sheet 8
count if gone past today 2
Problem with "IF" function 8
COUNTIF for date and amount 1
Non-Expiring Data Sim Card? 4
Countif with Dynamic date ranges. 2
COUNTIFs dates on a cloumn are within the last 30 days 0

Back
Top