Link to home
Start Free TrialLog in
Avatar of swjtx99
swjtx99

asked on

VLOOKUP to add x "network" days to a date

Hi,

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,

swjtx99
Avatar of Professor J
Professor J
where is the attachement?
Avatar of swjtx99
swjtx99

ASKER

Strange, not sure what happened.

Attached the example here
Book2.xlsx
Avatar of Professor J
Professor J
please find attached. the formula excludes the weekends of saturday and sunday and also the holidays. you can put the holidays in the cells highlighted in yellow. for example i have put christmas holidays with new year. you can add more if you want
Book2.xlsx
Avatar of swjtx99
swjtx99

ASKER

Hi Professor,

Not sure I explained myself well enough. The date in Column E needs to be 20 network days (because the status is "warm") later than the date in column D. My formula makes it 20 calendar days later but what I need is 20 network days (also excluding holidays).

Thanks for your help,

swjtx99
Avatar of Professor J
Professor J
ok see now.

attached.
Book2.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Professor J
Professor J
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of swjtx99
swjtx99

ASKER

Hi Prof,

Thanks. Once I see it I think. Aggh, simple! ....but I wasn't able to get there.

Thanks again,

swjtx99