Change the date of Specific Days

[masfouaa]

Hello everybody 

I need a formula or tool can select specific day to change them like below  statements: 

• "if the day is Friday then the date will decrease by 1 day" 
• "if the day is Saturday then the date will decrease by 2 days"

[binuacs · Accepted solution]

Switch(DateTimeFormat([Due Date],"%A"),[Due Date],"Friday",DateTimeAdd([Due Date],-1,"days"),"Saturday",DateTimeAdd([Due Date],-2,"days"))

スポイラ

[masfouaa]

Incredible!

thanks a lot.. ^^