Free Trial

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 #359: Manipulating Dates

Dina
9 - Comet

Done

mdm
8 - Asteroid
Spoiler
mdm_0-1679731786629.png

 

 

This solution can handle any fiscal year end. You may define which month as the fiscal year end. The default month is defined in the Text Input tool.

Desmond
8 - Asteroid

My solution

MilindG
12 - Quasar
Spoiler
MilindG_0-1680031372827.png

 

lyon_abido
8 - Asteroid

Cool challenge!

 

Spoiler
Screenshot (168).png
karlhansen
9 - Comet
Spoiler
solution_359.jpg
JS1989
8 - Asteroid

Solution

dYoast
11 - Bolide

One overly complicated formula later...

Spoiler
dYoast_0-1680286237499.png

 

dYoast_1-1680286258515.png

 

Reesetrain2
9 - Comet
9 - Comet

All,

I used a Text input and some code that I found in the community for my solution!

Spoiler
Capture.PNG

brianfia
8 - Asteroid
Spoiler
c_359_Manipulate_Dates_brianfia.PNG