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