VLOOKUP to calculate dates - holidays = due date
My Eval Pull date is based upon the TCP Type the user selects and also needs to calculate in the holidays.
Currently, Eval Start Date has a reference to another cell =[Date Completed]32
Once the Date Completed/Eval Start Date has a date, based upon the users pre-selected TCP Type of 115 days (VLOOKUP to TCPTypeDropDown and TCPTypeValue), an Eval pull date should be calculated off of that minus the holidays listed.
My current formula with the VLOOKUP in my Eval Pull Date is
The formula that I used when dealing with holidays, NOT using VLOOKUP, is
Can I merge the two and if so, how?
Thank you :)
Help Article Resources
Check out the Formula Handbook template!