View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
WSR WSR is offline
external usenet poster
 
Posts: 4
Default UK Business Days Formula

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?