I want to add a number of days to a date and get the new calendar date but also account for bank holidays.
cell A1 a date
number of days to add
bank holidays in cells A3:I3
something like this
=WORKDAY.INTL(A1, 90, 7, A3:I3) but this is working days and takes into account the bank holidays
please can you help as I'm lost? I have done Goggle searches but could not find what I wanted or I did not understand them
thanks
smiler44
cell A1 a date
number of days to add
bank holidays in cells A3:I3
something like this
=WORKDAY.INTL(A1, 90, 7, A3:I3) but this is working days and takes into account the bank holidays
please can you help as I'm lost? I have done Goggle searches but could not find what I wanted or I did not understand them
thanks
smiler44