VLOOKUP to add x "network" days to a date
Posted on 2014-11-01
I have a formula in a cell that adds a number of days specified using a VLOOKUP to a date in another cell. Works fine.
Problem is I need it to add x number of "network" days to the date in the other cell.
In the attached example, the formula in column E adds the number of days associated with the status on sheet2 for each line where the status on sheet1 matches.
Hope this makes sense :-)
Thanks in advance,