Excel Date Calculation
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.
|