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
------------------------------
Question
WEEKDAY function
+11This topic has been closed for replies.
+24WeekDayAdd([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
------------------------------
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
------------------------------
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.