Workday Formula Help - accounting for weekends and workdays
//[Date of Survey]+Days(3)
ToDate(WorkdayAdd(ToWorkDate([Date of Survey]),3))
The issue is to skip the weekend days when a due date counts only business days MON-FRI.
For ex: 9DEC is a FRI therefore a due date should be three business days returning WED14DEC. But the line 1 formula doesn't account for the weekend and returns MON12DEC as a due date.
The second, more intricate formula, also does not work.
First and Second Prizes to any suggestions!
------------------------------
marc viens
------------------------------
ToDate(WorkdayAdd(ToWorkDate([Date of Survey]),3))
The issue is to skip the weekend days when a due date counts only business days MON-FRI.
For ex: 9DEC is a FRI therefore a due date should be three business days returning WED14DEC. But the line 1 formula doesn't account for the weekend and returns MON12DEC as a due date.
The second, more intricate formula, also does not work.
First and Second Prizes to any suggestions!
------------------------------
marc viens
------------------------------
