Crystal Reports Formula for Calculating Days Outstanding (In Business Days)

REMOVE “Shared” if trying to sum up the formula

This formula does not account for Holidays.

-change/ insert Order Date & Ship Date to desired field

Shared DateTimeVar d1 := {Orders.Order Date};

Shared DateTimeVar d2 := {Orders.Ship Date};

DateDiff (“d”, d1, d2)

• DateDiff (“ww”, d1, d2, crSaturday)
• DateDiff (“ww”, d1, d2, crSunday)