returning a date 7 business day excluding holidays in the future

E

excelrookie

How would I write a formula that would do this. If I input a date in cell A1
and I have holidays in cells R1:R11. Can I write a formula that would give
me a date in cell B2 that is 7 business days excluding holiday from the date
in A1.

I am having a hard time getting the networkdays and holidays working if I am
not inputing 2 dates.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Future date with six day week including holidays 1
How to Time time Diff for Completion of Activity (Exc Holiday List & Non Bus Hours) 2
Date Calculation Formula- Calendar days minus Holidays 1
Date Calculation question 3
Total Leave 6
Calculate the number of days to exclude Sunday & Holidays 6
End Date/Time adding business hours 1

Top