In this formula it assumes that C7 is the start date and will push the end date forward if the end date falls on a weekend, however I also need it to push the end date forward if the end date falls on the weekend and then a holiday. As in the highlighted example line of the attachment.
=C7+45+LOOKUP(WEEKDAY(C7+45),{1,2,7},{-2,0,-1})
How can I modify the formula to accomplish this?
Last edited by KMTrombley; 03-24-2010 at 11:57 AM. Reason: Still trying to find the best way to calculate this
Try =WORKDAY(C2+45,1,DATE(2010,9,6)). You may have to enable the Analysis Toolpak, which comes with 2007.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks