Forum Discussion

marcviens's avatar
Qrew Member
2 years ago

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

1 Reply

  • Try
    WeekDayAdd([Date of Survey],3)

    Mark Shnier (Your Quickbase Coach)