Thread
: [Solved]
weekend to monday logic problem
View Single Post
08-02-2017, 03:30 PM
macropod
Windows 7 64bit
Office 2010 32bit
Administrator
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
Suppose the initial date is in A1 and the deadline offset (the 10 days) is in B1. In that case, the inspection date could be calculated as:
=A1+B1+(MOD(A1+B1,7)<2)*(2-MOD(A1+B1,7))
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
macropod
View Public Profile
Find all posts by macropod