Adding Working Days to a Formula

G

Guest

I have a spreadsheet that includes a column of dates. I want to show a
column next to this that shows what the date would be in 40 working days. I
cannot use the network days formula as I only have the one date. I need to
ensure that the formula allows for Bank Holidays as well as weekends.

Can anyone help?
 

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

Working Days function copied down column 1
Trailing 30 days sum calculation with excel 1
Working out a future date with formulas 3
Date Formula Excluding Weekends 3
Formula adding 2 days... 2
Diff in business days 2
Template for calculating different number of days between 2 dates 1
Excel formula where I can add business days (date) 3

Top