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 #41:
Spoiler
flow
Formulas:
Spoiler
Give everyday a number:
Switch(DateTimeFormat([Start],"%a"),
0,
"Sun",0,
"Mon",1,
"Tue",2,
"Wed",3,
"Thu",4,
"Fri",5,
"Sat",6)
Formula for days diff:
IIF([Start]>[End],
Null(),
1 +
((DateTimeDiff([End],[Start],"days")*5 - ([StartWeekday]-[EndWeekday])*2) / 7) +
IIF([EndWeekday]==6,-1,0) +
IIF([StartWeekday]==0,-1,0)
)
