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

Future date with six day week including holidays 1
Date Calculation Formula- Calendar days minus Holidays 1
Total Leave 4
Date Calculation question 3
Date Calculation problem 3
How to get Holidays in cell/s? (Find explaination in details) 3
networkdays and holidays 2
Calculate the number of days to exclude Sunday & Holidays 6

Top