Hello, I am trying to create two duration formulas. One is the duration is between request date and manager approval date and the other is the duration between manager approval date to admin approval date. All three of the date columns are the date column type. The date columns are filled in automatically by Workflows.
I need these formulas to also calculate in the company holidays and weekends so that it doesn't inflate the metrics. I do not want to utilize the Gantt chart features. I am trying to keep this sheet simple since it is an intake tracker I will be handing off. If anybody has any ideas on how I can use a formula to calculate duration that would be very helpful.
The formula I created originally worked but now it says "Invalid Data Type". The first formula is:
=IF([Request Date]@row = [Manager Approval Date]@row, 0, NETWORKDAYS([Request Date]@row, [Manager Approval Date]@row, {Copy of Amgen Holidays Range 2}))
The second formula is
=IF([Manager Approval Date]@row = [Admin Approval Date]@row, 0, NETWORKDAYS([Manager Approval Date]@row, [Admin Approval Date]@row, {Copy of Amgen Holidays Range 2}))