Forum Discussion
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.
=IFERROR(A2+(VLOOKUP(I2,Costs,WEEKDAY,2,0)),"")
Thanks
- Amazing. rights words but wrong order.
