Hi,

I want to add 15 days to date. After adding 15 days to a date, if the date is under (holiday list, Saturday & Sunday) then final date should be next working day.

I tried this "=WORKDAY(A2,15,B$3:B$6)",

A2= starting date
15 =number of days to add
B$3:B$6= holiday list.

but this omits the Saturday's & Sunday's from the begning itself. what i need is Saturday and Sunday need to included., if in case the final date comes under Saturday/Sunday/Holiday then the result should be next working day

Thanks in advance.