Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 days, so please help. Thanks John |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 days, so please help. Thanks John |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 days, so please help. Thanks John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to count number of days in range which are less than today | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count the number of dates in a range that are earlier than today. | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions |