Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語

IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Had a little fun with this one. Made it general purpose so that with a tweak to the inputs it could accept any number of holiday files and an arbitrary number of Employee/Region pairs in an employee file. Did this with a macro first then realized there was an easier way.

No filters

Generate rows for weekdays onlyBlue = both, Red = US, Green = AUS

Hi! Here my solution 🙂

Thanks @Tony_Castillo

9 KB

This is an easy one? So we dont have a hard time for the new year?😁

Happy New Year!

10 KB

Here is my solution:

Challenge #248 in the can

Challenge #248 in the can

My solution.

Bonus

Here is my workflow: