|
|
#1
05-26-2016, 03:10 AM
|
|||
|
|||
Help With a Formula
Hi All
I have found a formula on this forum that counts the number of days in each month between a given start and end date. However I need to modify it so that it gives me the number of working days and excludes UK bank holidays. The formula is below for information: =MAX(0,MIN(EOMONTH(C$1,0),$B3)-MAX(C$1,$A3)+1) Any help would be appreciated. Thanks in advance. Tony 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need help with dragging a formula and changing a reference column as I drag the formula. | LupeB | Excel | 1 | 10-22-2015 03:02 PM |
| help with a formula | srockwell25 | Excel | 4 | 08-22-2014 02:47 AM |
 Formula
|
Excel | Excel | 1 | 08-14-2014 05:11 PM |
| Formula Help | clo312 | Excel | 11 | 01-11-2014 02:54 AM |
| Formula Help | OTPM | Excel | 5 | 02-21-2013 08:03 AM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode