NETWORKDAYS
This Function allows you to calculate the number of working days between two given dates. It will exclude weekends when calculating the difference.
NETWORKDAYS( <date_field or date 1> , <date_field or date 2> )
-
date_field or date 1: The date field or date to calculate from.
-
date_field or date 2: The date field or date to calculate to.
Note: dates in Audiences need to be formatted as either YYYY-MM-DD or MM/DD/YYYY. Entering a date as 01-02-2023 would be read as Jan-2 not 1-Feb.
Example: Create a field on the ORDER table that calculates how many working days before Christmas 2016, the order was made.
NETWORKDAYS( [Order.OrderDate] , "25122016" )