This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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...
