Challenge #41: Analytics PayPeriodCalc

[gawa]

I wanna get paid twice

Spoiler

[gawa]

Solution attached

[Rana_Kareem]

Spoiler

 

[Dani_Lin]

solved

[MDestra]

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)

)

[lwolfie]

Solved

[Stacies]

Solved

[MattPett]

Very helpful, would love to go back and solve with RegEx tool!

[Tgigs]

My solution attached

[dwstada]

my solution :)

Spoiler