excel today countif over expired date

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 replies in .Misc

Biff

"JonnieP" <[email protected]> wrote in message
news:[email protected]...
> 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


JonnieP wrote:
> 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