Average if and networkdays

K

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

T. Valko

NETWORKDAYS won't work on arrays.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top