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 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
Business Days Between Two Dates? 4
Formula to determine 10 business days 2
Add days to a date, but exclude holidays 13
Adding business days to a date 2

Top