Thread: Formula for calculating dates based on Business Days
View Single Post
 
Old 02-28-2020, 01:35 PM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2016
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
Have a look at the Workday() function:


e.g. =WORKDAY(A1,14) will add 14 business days to date in A1.


You even can include specified holiday dates to avoid in the calculation.
Reply With Quote