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

Challenge #86: Create a Macro that Generates Past Dates

lisahitch95
8 - Asteroid
Spoiler
Screenshot 2023-12-12 092032.png

tristank
11 - Bolide

The intermediate challenges go from easy to painful back to easy etc...

 

Spoiler
Screenshot 2023-12-12 171835.pngScreenshot 2023-12-12 171830.png
Rob-Silk
8 - Asteroid

My solution below - took a bit of Googling to find out how to lock a macro, but was a useful thing to learn for the future!

 

Spoiler
challenge_86_RS_screencap.PNG
olga_strubbe
10 - Fireball

A fun challenge, thank you, @JoeM!

I built an app to include a Q on exclusion/inclusion of weekends in the results. 

 

Results I: Include weekends

include weekends.png

 

Results II: Exclude weekends

2024-01-08_11-49-18.png

 

Analytic App:

2024-01-08_11-54-37.png

Tgigs
8 - Asteroid

My solution attached.

 

Spoiler.PNG

MilindGadhia
7 - Meteor

solution attached

ckoo22
8 - Asteroid

This is my first time creating an encrypted macro, I had fun learning about it.

H_a_n_g_C_h_e_n__x3
8 - Asteroid

Another One

danbostrom
8 - Asteroid