Average if and networkdays

[K]

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 Rcvd>7/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?

 

[T. Valko]

NETWORKDAYS won't work on arrays.

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