Hello Community members!
A solution to last week’s challenge can be found here.
This week’s challenge was submitted by Jay Zhen @jialiangzhen . Thank you, Jay, for this great challenge!
Imagine you work for a large organization’s accounting department. You are responsible for organizing the payment schedule for the year based on specific dates.
The entire company’s payments must be completed by the 6th workday of each month. You want to use Designer to organize a schedule for the entire year. The provided dataset contains the 2024 calendar and company holidays. Your task is to determine when the 6th workday is for each month in 2024. A workday is defined as any weekday from Monday to Friday (excluding company
holidays).
Note: If you get stuck, check out the Hints box included in the workflow.
Need a refresher? Review the following lessons in Academy to gear up:
Joining Data
Numeric Functions
Good luck!
The Academy Team
