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
アステロイド
スポイラ
Screenshot 2023-12-12 092032.png

tristank
ボリード

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

 

スポイラ
Screenshot 2023-12-12 171835.pngScreenshot 2023-12-12 171830.png
Rob-Silk
アステロイド

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!

 

スポイラ
challenge_86_RS_screencap.PNG
olga_strubbe
ボリード

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
アステロイド

My solution attached.

 

Spoiler.PNG

MilindGadhia
メテオール

solution attached

ckoo22
アステロイド

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

H_a_n_g_C_h_e_n__x3
アステロイド

Another One

danbostrom
アステロイド

 

 

aatalai
パルサー

C86