Subtract Business Days from a Date

[carmine1]

In Crystal Reports, how to subtract a number of business days (Monday through Friday) from an input date?

For example, October 29, 2024 - 16 business days = October 7, 2024

[leonardo0482]

To subtract business days in Crystal Reports (Monday to Friday), you can use a formula that iterates back through dates while skipping weekends. Since Crystal Reports doesn’t have a built-in function for business days, we’ll use date functions with a loop. Here’s a formula you can use: Define the starting date and the number of business days to subtract. In this case, the start date is #10/29/2024# and the business days to subtract are 16. Create a formula to perform the calculation:

[ido_millet]

See https://kenhamady.com/formulas/form17.shtml