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

LynnPätzold
8 - Asteroid

my solution:)

Yogesh1795
8 - Asteroid

Once we are comfortable with formulas, challenges become super easy

tmich20
8 - Asteroid
Spoiler
tmich20_0-1682394225316.png

 

Abhishek2412
7 - Meteor

My Submission

Carolyn
12 - Quasar
12 - Quasar

Completed!

 

I did my quarters manually but it looks like newer versions of Designer have a Quarter function?

Asmaa-jirani
5 - Atom
Spoiler
Asmaajirani_0-1682612521287.png

 

Zas3nfkb
8 - Asteroid
Spoiler
Zas3nfkb_0-1682619784793.png

 

VladimirR
8 - Asteroid

Lot of different ways, but below are first three ideas that came to mind. 

Spoiler
However, in all three formulas I'm getting the Q number by dividing the month number by 3 and then rounding it up with CEIL function. Rest is just how I handle date/string formats and parsing.

VladimirR_0-1683579931063.png

 

 

elena_mazareanu
8 - Asteroid

Solved

TungThanhHo
8 - Asteroid

my solution