//[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
------------------------------
Question
Workday Formula Help - accounting for weekends and workdays
This topic has been closed for replies.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.