Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
3 years ago

WEEKDAY function

Need formula to include weekday count only

date field [START - HANG] +
numeric field [DW DAYS ALLOWED] =

date field [TARGET SAND DATE]

[START - HANG] = 3/24/2022
[DW DAYS ALLOWED] = 8
[TARGET SAND DATE] should equal 4/4/2022
thank you

------------------------------
BuildPro
------------------------------

1 Reply

  • WeekDayAdd([START - HANG],[DW DAYS ALLOWED])

     you may need to subtract 1 because 1 + 1 = 2, but maybe a 1 day job ends on day 1.


    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------