I created two calculated columns to calculate the difference between Payment Date and Transfer Date, one of which is the "Duration" (between the payment and transaction) and the other is "Days Since Payment" (In case the transaction is not done).
My question is that CAN I make the duration column and the Days Since Payment skip and not count the weekends?
Say Payment Date is OCT 27 2019 .. TODAY IS NOV 5 2019 .. the Duration should be 7 days if we exclude the weekend.
Here are the formulas I applied: Duration Column =IF(ISBLANK([Transfer Date]),"N/A",DATEDIF([Payment Date],[Transfer Date],"d"))
Days Since Payment =IF(ISNUMBER([Duration (Days)]),"Closed Transaction",DATEDIF([Payment Date],TODAY(),"d"))
Help please and thank you!