ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Average Days Open IF between dates (https://www.excelbanter.com/excel-worksheet-functions/119037-average-days-open-if-between-dates.html)

kathi

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


Roger Govier

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 12:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com