UK Business Days Formula

  • Thread starter Thread starter WSR
  • Start date Start date
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?
 
Back
Top