Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
UK Business Days Formula
1 view
Skip to first unread message
WSR
May 27, 2008, 8:46:04 AM5/27/08
to
I work in the US but need to create a 10 Business Days differential date
between today.
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
May 27, 2008, 9:00:01 AM5/27/08
to
Workday(B4,10,holidays)
0 new messages