| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Subtracting Business Days | Excel Worksheet Functions | |||
| Excel formula where I can add business days (date) | Excel Discussion (Misc queries) | |||
| Business Days Only | Excel Discussion (Misc queries) | |||
| Date Formula Needed-Business Days | Excel Discussion (Misc queries) | |||
| Formula to make Excel count business days/skip weekends? | Excel Worksheet Functions | |||
Hybrid Mode
