UK Business Days Formula

W

WSR

I work in the US but need to create a 10 Business Days differential date
between today.

The twist is, Business Days are defined as any day other than Saturday,
Sunday or any other day on which banks in London England are required by law
to be closed for business.

Cell B4 =Now()
Cell B6 =Workday(B4,10)

However, my 10 Business Days needs to account for UK Bank Holidays not just
Monday thru Friday

Any suggestions?
 

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

Exclude weekends when counting days only on day 29 or 30 3
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Formula to make Excel count business days/skip weekends? 1
Calculate workdays for irregular work patterns 1
How to calculate the number of Workdays for irregular work pattern 1
No of Days between two dates and offset formula 4
Formula to determine 10 business days 2
Adding business days to a date 2

Top