Hello all,
I don't think my issue is as complicated as some of the ones I've seen on this site but i think my lack of understanding in the formula is causing me problems.
I was instructed to gather some metrics using data from out ticketing system. This is where i am running into problems, I need to find out how many work days away from target was the ticket completed. Our ticketing system uses 2 separate columns for target date one for HR related tickets the other for all the rest. I managed to get it to a point where i can get the amount of days between the dates using the formula bellow but i don't know where i would insert the NETWORKDAYS and Holidays portion.
here is an example:
<tbody>
</tbody>
Current formula: =IF(B1="",C1-A1,IF(A1="",C1-B1))
I don't know if there is a better way of doing this so I will gladly accept any assistance you can provide.
Thanks in advance
I don't think my issue is as complicated as some of the ones I've seen on this site but i think my lack of understanding in the formula is causing me problems.
I was instructed to gather some metrics using data from out ticketing system. This is where i am running into problems, I need to find out how many work days away from target was the ticket completed. Our ticketing system uses 2 separate columns for target date one for HR related tickets the other for all the rest. I managed to get it to a point where i can get the amount of days between the dates using the formula bellow but i don't know where i would insert the NETWORKDAYS and Holidays portion.
here is an example:
A | B | C | D | |
1 | Target Date | HR Target date | Completed Date | Days from Target |
2 | 03/21/2018 | 05/03/2018 | 43 | |
3 | 04/10/2018 | 05/03/2018 | -5 |
<tbody>
</tbody>
Current formula: =IF(B1="",C1-A1,IF(A1="",C1-B1))
I don't know if there is a better way of doing this so I will gladly accept any assistance you can provide.
Thanks in advance