This content has been marked as final. Show 2 replies
At its simplest, you need a calculation field, unstored, result Date, maybe called yournextworkingday:Let ([dw = DayOfWeek ( yourdate )];( Case (dw = 6 ; yourdate + 3 ;dw = 7 ; yourdate + 2 ;yourdate + 1)))always assuming that Monday-Friday are your normal working days, so that DayofWeek = 1, 2, 3, 4 or 5 defaults to date +1. (DayOfWeek = 1 = Sunday)
Thanks so much!!!