Hi, I tried solving this but no avail.
If Payment Date falls on Friday(e:g 1/5), Saturday and Sunday, it should return a following Monday (1/8). If it’s Mon-Thu, keep the original date.
My Code:
IF(5-WEEKDAY({Payment Date})<=0, SWITCH( WEEKDAY({Payme...