|
Number of rows over 30 days after creation
Hello, I am looking for a formula that would allow me to count the number of
rows that have a date in col N6:10000 and of them are over 30 days old that have don't have a date in col AA6:10000 which indicates that the row has been 'closed' I was thinking i'd need an 'imput todays date' cell (though if there was not a need for onew that would be great) and that cell is K2 I created column that gives the date of col N+30 which is col AJ and col AI returns a 1 or 0 if the col AA has a date in it or not. so i tried the formulas : =COUNTIFS(N6:N10000,"*",AI6:AI10000,"0",AJ6:AJ1000 0,"today()") Returns zero? & =COUNTIFS(N6:N10000,"*",AI6:AI10000,"0",AJ6:AJ1000 0,"K2") Again returns zero? Can anyone advise on what i am missing or if there is an easier way to calulate this? -- Jim |
Number of rows over 30 days after creation
Maybe
=SUMPRODUCT(--(N6:N100000),--(N6:N10000<=TODAY()-30),--(A6:A10000=0)) Your request wasn't very clear! -- Regards! Stefi €˛Jim€¯ ezt Ć*rta: Hello, I am looking for a formula that would allow me to count the number of rows that have a date in col N6:10000 and of them are over 30 days old that have don't have a date in col AA6:10000 which indicates that the row has been 'closed' I was thinking i'd need an 'imput todays date' cell (though if there was not a need for onew that would be great) and that cell is K2 I created column that gives the date of col N+30 which is col AJ and col AI returns a 1 or 0 if the col AA has a date in it or not. so i tried the formulas : =COUNTIFS(N6:N10000,"*",AI6:AI10000,"0",AJ6:AJ1000 0,"today()") Returns zero? & =COUNTIFS(N6:N10000,"*",AI6:AI10000,"0",AJ6:AJ1000 0,"K2") Again returns zero? Can anyone advise on what i am missing or if there is an easier way to calulate this? -- Jim |
| All times are GMT +1. The time now is 05:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com