Weekday with Vlookup

Contributor

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. 

 

=IFERROR(A2+(VLOOKUP(I2,Costs,WEEKDAY,2,0)),"")

 

Thanks

2 Replies

@Jamesboden 

Perhaps

=IFERROR(WORKDAY(A2,VLOOKUP(I2,Costs,2,FALSE)),"")

Amazing. rights words but wrong order.