Cloud Quest 35: Pay Period Calculator

[AYXAcademy]

Hi Community,

We posted the solution JSON file to Cloud Quest #34. Check it out and let us know what you think! Send suggestions to academy@alteryx.com or leave a comment below!

Let’s dive into this week's quest!

1. Download the provided JSON file containing your starting data and workflow files.
2. Upload Start Cloud Quest 35.json file to your Analytics Cloud library.
3. All necessary datasets are contained within Text Input tools in the workflow.

For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article Cloud Quest Submission Process.

 

Scenario:

You work for a company that pays employees twice a month, so the number of days in each pay period can vary. Your task is to:

• Calculate the number of weekdays (excluding weekends) in each pay period for every month.

• Sort the output in ascending order by date.

Hint: Use the Generate Rows tool to fill in the days between P1/P2 Start and End values.

Image and dataset generated by ChatGPT, May 27, 2025, OpenAI, https://chat.openai.com.

 

Earn Cloud Quest badges:

After completing your quest, head back to your Analytics Cloud library:

• Download your workflow solution file.
• In your reply, attach both your JSON solution file and a screenshot of your workflow.
• Keep submitting—every solution gets you closer to earning more Cloud Quest badges!

 

Here’s to a successful quest!

- The Academy Team

Download Start File

[JeffF]

Solved two ways.

Spoiler

[Qiu]

@JeffF Nicely done with the function of DateTimeWorkDays.

I will just go with the conventional way. 😊

Spoiler

[patrick_digan]

Spoiler

[Carolyn]

Solved!

I forgot about the DateTimeWorkdays formula. I even thought about how I thought it was a thing, but then was lazy and just did it the long way :D 

Spoiler

[Qiu]

@patrick_digan 
Very simple and elegant 👍

[RWvanLeeuwen]

Here's my take (just 3 tools, including a Select tool)

Spoiler

[alexnajm]

Done!

Spoiler

[jkv0019]

Submission attached

[AkimasaKajitani]

My solution.

Spoiler

I'm surprised at being able to use the DateTimeWorkDays formula in cloud because it is the new feature in the Designer Desktop version 2025.