Skip to main content
Question

Workday Formula Help - accounting for weekends and workdays

  • December 13, 2022
  • 0 replies
  • 71 views

//[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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Try
WeekDayAdd([Date of Survey],3)

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------