Weekday with Vlookup


Hey Guys 


Not sure if this is possible. But i'm working with SLA times and I have different SLA for different things. I'm using Vlookup to find the correct number of days based on the contract. this is then added to the date the job was logged. Eg. today date. Contact 1 = 2 day. However i need to work on weekdays only. 


Here is the formula I have but think I'm off base. Any suggestions would be helpful. 





2 Replies




Amazing. rights words but wrong order.