Challenge #41: Analytics PayPeriodCalc

[Anastasiia]

Here is my solution

[cplewis90]

Cool problem to look at day counts in a different way outside of 7 days a week.

Spoiler

[gradyjofficial]

my solution

[JonathanAllenby]

Here's my solution to Challenge 41!

[TonyA]

This is probably the toughest "Beginner" challenge I've seen so far. 

Spoiler

I took a rules based approach. I built a formula to get the DOW then broke the problem into parts. The 15 day periods were easy -- if the period started with a weekend day, then there were 10 workdays, else there were 11. For the second part I found out how many 7 day periods there were and then did a conditional formula on the remainder to determine the number of weekdays. Then cleaned up the mess. It isn't pretty but it works.

[Sajeel_Kershi]

completed using formula tool to convert to dates and then formula to calculate number of weekdays

[papalow]

Not as clean as I would have hoped, but it gets the job done.

[hanykowska]

Good one, I think my flow is not the most optimal option but it works

[AmNotARobot]

Completed, but with a significant debt of thanks to jdunkerly79's posting of ‎11-22-2017 12:10 AM. Now I wish to find out how to store this formula (and others) in my own function library.

[Thableaus]

Challenge #41, done.

Lazy solution (probably this could be done with a single formula tool, or a Multi-Field formula tool with a formula tool ahead of it).

Spoiler

Cheers,