Target Met formula

ArviLaanemets · #14 06-13-2018, 10:42 PM

There I no clue based on which columns are calculated values for AJ:AR, but I think for AJ this must be something like

Code:

=NETWORKDAYS(
          Table2[@[Date received]]+
                    IF(
                              AND(
                                        Table2[@[Time received]]>0,5;
                                        Table2[@[Date received]]<Table4[@[Date completed acceptance slip received from employee]]);
                              1;
                              0
                    );
          Table4[@[Date completed acceptance slip received from employee]];
          Holidays
)

NB! When time received > 12:00, then the calculation of working days starts from next day, except cases, when task is completed on same date.

Btw. With Table formulas, it is reasonable (to make reading and editing formulas easier):
1. to avoid special characters and spaces in column names;
2. to keep column names as short as possible.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
vba to replace old value by target value search almost key words matching	manilara	Excel Programming	6	11-19-2015 08:19 PM
Insert space before and after target text	Marrick13	Word VBA	6	06-20-2014 07:46 AM
Envelope Printing is off target - need help please!	mylan	Word	2	10-24-2012 12:24 PM
Send OFT when target email arrives	RandWald	Outlook	0	11-11-2011 10:52 AM
Target line on a excel graph	leroytrolley	Excel	1	01-16-2009 04:19 PM