date add

[jimpatel]

Hi,

Thanks for looking at my post.

I have below formula and can anyone help me to modify this to add 2 days on top of this please?

 Date = SWITCH(TRUE(),

         WEEKDAY( 'Table'[ReceiptDate] + 1,1) = 7 , 'Table'[ReceiptDate] + 3, 'Table'[ReceiptDate] + 0

)

[jimpatel]

Perfect

Thanks a lot 

[Elcin_7 · Accepted solution]

Hi,

Date  = SWITCH(

            TRUE(),

            WEEKDAY( 'Table'[ReceiptDate] + 1,1) = 7 , 'Table'[ReceiptDate] + 3+2, 'Table'[ReceiptDate] + 0+2

)

another version

Date  = SWITCH(

            TRUE(),

            WEEKDAY( 'Table'[ReceiptDate] + 1,1) = 7 , 'Table'[ReceiptDate] +5, 'Table'[ReceiptDate] + 2

)

I hope, I understood the requirement correct.