Average if and networkdays
 

Hi guys,

I have a formula help that I need with taking an average number of days
between 2 days if a certain criteria is met. Below are some things that will
help.

Date Array 1: Log_Date_Rcvd
Date Array 2: Log_Close_Dt
Status: Log_Status
Other array: Holidays

Criteria: If Date Rcvd7/1 and date close<7/31 and Log status = Closed

if so calculate networkdays between dates - holidays and provide the average.

the end result should be one number that is basically taking the average of
a record's start and end dates provided they are within that month and closed.

I tried a couple of things but either my syntax is off or something. Can
you guys help me out?

Average if and networkdays
 

NETWORKDAYS won't work on arrays.

You'd have to do individual calculations then get the average.

--
Biff
Microsoft Excel MVP


"K" wrote in message
...
Hi guys,

I have a formula help that I need with taking an average number of days
between 2 days if a certain criteria is met. Below are some things that
will
help.

Date Array 1: Log_Date_Rcvd
Date Array 2: Log_Close_Dt
Status: Log_Status
Other array: Holidays

Criteria: If Date Rcvd7/1 and date close<7/31 and Log status = Closed

if so calculate networkdays between dates - holidays and provide the
average.

the end result should be one number that is basically taking the average
of
a record's start and end dates provided they are within that month and
closed.

I tried a couple of things but either my syntax is off or something. Can
you guys help me out?