![]() |
Average Days Open IF between dates
I have a worksheet with invoices for the last four years. I need to average
the number of days between the order date and the shipped date. However, I also need to have the average number of days an invoice stays open for each quarter of the fiscal year. I have been given the following formulas to try =AVERAGE(IF(INT(MONTH(C:C)+2/3)=4 AND =AVERAGE(IF((YEAR('Copy Link'!$C$1:$C$196=F$32))*(INT((MONTH('Copy Link'!$C$1:$C$196)+2)/3)=F$33),'Copy Link'!$N$1:$N$196)) but they don't compute correctly for some strange reason. If you have any advice i would truly appreciate it. Any solution, please I really need to know answer. Thank you Kathi |
Average Days Open IF between dates
see response to your earlier question
-- Regards Roger Govier "kathi" wrote in message ... I have a worksheet with invoices for the last four years. I need to average the number of days between the order date and the shipped date. However, I also need to have the average number of days an invoice stays open for each quarter of the fiscal year. I have been given the following formulas to try =AVERAGE(IF(INT(MONTH(C:C)+2/3)=4 AND =AVERAGE(IF((YEAR('Copy Link'!$C$1:$C$196=F$32))*(INT((MONTH('Copy Link'!$C$1:$C$196)+2)/3)=F$33),'Copy Link'!$N$1:$N$196)) but they don't compute correctly for some strange reason. If you have any advice i would truly appreciate it. Any solution, please I really need to know answer. Thank you Kathi |
All times are GMT +1. The time now is 11:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com