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.

In attached file is a possible solution.

NB! It's better to leave the Weekday() function with European format - much easier for calculations when weekends are days 6 and 7.

PS. Without additional sheet it will be nearly impossible. You must move the date away from weekend, then move away from holiday when date happens to be one, then again you have to check that new dates aren't weekends and when , then move the date, then you have anew to check for holidays, etc.

Attached Files

FutureWorkday.xlsx (31.8 KB, 15 views)

If you have a post 2007 version look at the NETWORKDAYS.INTL function
If not their are tons of solutions out there

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi ArviLaanemets,

Thanks for your reply....
It's working fine