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)


If necessary, seek the assistance of Acute Data Systems to help provide assistance with this process.