Challenge #41: Analytics PayPeriodCalc

[Qiu]

Seems can not delete my post. come back later.

[simbert]

Fairly long formula used to exclude weekends, but got there in the end!

Spoiler

[rajatsadan]

@GeneR Very Interesting challenge!! Was able to approach the challenge in a different manner and finally arrive at the solution too. Got to utilize good number of tools!

[WernerE]

Thanks, picked up a few new tricks from this one.

[LukaszKarpinski]

My solution:

Spoiler

[Nicole_L]

That was a good one for multirow tool and generate rows. Thanks 

[wardboston]

Spoiler

Solution 

[Tokimatsu]

Solved.

Spoiler

 

[A2H]

Spoiler

[moray]

My first weekly challenge. I'm afraid I just used a lookup table as it was only 25 records (including five error conditions) and obviously it only works for a two week period so it not reusable in other use cases. I'll be more algorithmic next time!