# count if gone past today

1. ## count if gone past today

Hi

I have a large spreadsheet that i use to track works that have an expiry
date, which is always in a specific column, and i need to count how many jobs
have gone over that date.

So far I have a countif statement that allows me to see the jobs that are a
maximum of 7 days past today(due to restrictions in the amount of statement i
can use). So, for example =COUNTIF('sheetname'!H:H,(TODAY())-1) and then -2,
-3 etc.

I'm sure there is an easy way of doing this and will not be limited to 7
Thanks

John

2. ## RE: count if gone past today

You can use comparison operators in the countif: =countif(h:h,">=" &
today()-7)

"JonnieP" wrote:

> Hi
>
> I have a large spreadsheet that i use to track works that have an expiry
> date, which is always in a specific column, and i need to count how many jobs
> have gone over that date.
>
> So far I have a countif statement that allows me to see the jobs that are a
> maximum of 7 days past today(due to restrictions in the amount of statement i
> can use). So, for example =COUNTIF('sheetname'!H:H,(TODAY())-1) and then -2,
> -3 etc.
>
> I'm sure there is an easy way of doing this and will not be limited to 7
> Thanks
>
> John

3. ## Re: count if gone past today

Hi Jonnie

I don't really understand why you are limited in the amount of statements,
but anyway, one way round it would be to put the number of days overdue in a
cell, e.g. A1
Change formula to
=COUNTIF('sheetname'!H:H,(TODAY())-A1)
As you change the value in A1, so the count will vary.

Regards

Roger Govier

JonnieP wrote:
> Hi
>
> I have a large spreadsheet that i use to track works that have an expiry
> date, which is always in a specific column, and i need to count how many jobs
> have gone over that date.
>
> So far I have a countif statement that allows me to see the jobs that are a
> maximum of 7 days past today(due to restrictions in the amount of statement i
> can use). So, for example =COUNTIF('sheetname'!H:H,(TODAY())-1) and then -2,
> -3 etc.
>
> I'm sure there is an easy way of doing this and will not be limited to 7
> Thanks
>
> John

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1