Feature: Add WORKDAY Formula with Dynamic Days Input from Lookup Field

Please confirm that the feature request does not already exist

• I confirm there is no existing issue for this feature request.

Use case

Users managing deadlines, schedules, or business processes need to:

1. Calculate a future or past date by adding/subtracting a number of business days (e.g., "10 business days from September 1, 2026").
2. Automatically exclude weekends (Saturday and Sunday) and optionally holidays for accurate calculations.
3. Use a dynamic value (from a lookup field) to define the number of business days to add/subtract.

• Example: A "Processing Time" field in a linked table could contain the value 10, and the formula would use this value to compute the final date.

Suggested solution

Introduce a WORKDAY formula that:

• Adds or subtracts a specified number of business days to/from a start date, excluding Saturdays and Sundays.
• Accepts an optional list of holidays to exclude from the calculation.
• Allows the number of business days to be defined via a lookup field (or linked field).
• Follows an intuitive syntax, similar to Excel: WORKDAY([Start Date], [Number of Days], [Holidays List])

Example with a lookup field: WORKDAY([Start Date], [Processing Time (Lookup)], [Holidays Table])

Where:

• [Start Date] is the starting date.
• [Processing Time (Lookup)] is a linked field containing the number of business days to add.
• [Holidays Table] is a reference to a list of dates to exclude.

Additional context

Impact:

• Eliminates manual, error-prone calculations.
• Enables full automation of date calculations based on dynamic business rules (e.g., varying lead times by request type).
• Compatibility: Should work seamlessly with existing date functions (TODAY, DATEADD, etc.) and lookup fields.