I have a puzzle I'm trying to solve. I am provided an end date to which I have predefined parameters for interim due dates (example: end date - 10 business days). I need to include a defined holiday table that will also factor into the calculation that also includes banking holidays. Is there another function I am overlooking? I am not very experienced with Excel programming.
END DATE MILESTONE1 MILESTONE2 MILESTONE3
12/31 -10 DAYS -13 DAYS -20 DAYS
Please and thank you for your assistance.
have you tried subtracting using the workday() function workdays calculates the number of days and accepts a range of holidays
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
See the WORKDAY function.
Entia non sunt multiplicanda sine necessitate
This is how to calculate a start date knowing the end date, the number of work days, weekends and holidays.
End Date Start Date =WORKDAY.INTL(B1,B4*-1,1,A7:A10) Work Days Holidays
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks