Help
Gladys_Lim
4 - Data Explorer
4 - Data Explorer
since ‎May 31, 2021
‎Nov 29, 2022

User Statistics

  • 3 Posts
  • 0 Solutions
  • 0 Kudos given
  • 0 Kudos received

User Activity

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...