Aug 17 2022 03:29 AM
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
Aug 17 2022 03:52 AM