Count Days in between, without weekends / day of

Elaine Mullis

Screen Shot 2021-07-17 at 7.40.35 PM.png

Hello,

I am trying to create a formula where "Aging of Orders" represents the days between "Actual delivery date" and "Requested Due Date", not including weekends or the "day of". Example - Line 1 I would consider 2 days late, not 3. Due: 1/14/21 Delivered: 1/18/21.

I appreciate any help!

Bassam Khalil

Hi @Elaine Mullis

Hope you are fine, please try the following formula:

=NETWORKDAY([Actual Delivery Date]@row, [Request Due Date]@row)