ExcelBanter - UK Business Days Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - UK Business Days Formula (https://www.excelbanter.com/excel-worksheet-functions/188948-uk-business-days-formula.html)

WSR

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?

Teethless mama

UK Business Days Formula

Workday(B4,10,holidays)

"WSR" wrote:

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?

All times are GMT +1. The time now is 07:13 AM.