Spreadsheet: 86196d1286225422-difference-in-days-excluding-saturday-and-public-holiday-workdays-holidays
Sheet: Sheet1

Start Date | End Date |  | Difference |  |  |  |  |  |  |  |  |  | Public Holidays | Holiday Weekday Number
2010-09-06 00:00:00 | 2010-09-13 00:00:00 | Marv's>> |  |  | <<< New formulas to see if 2 Saturdays are between dates |  |  |  |  |  |  |  | 2008-01-01 00:00:00
 |  | Formula>> |  |  | I had to see if Weekday of the end was less than the beginning |  |  |  |  |  |  |  | 2008-01-10 00:00:00
 |  | Was>> |  |  | If it was then an extra Saturday needs to be subtracted. |  |  |  |  |  |  |  | 2008-02-01 00:00:00
 |  | Wrong>> |  |  | <<<< This is the correct [NAME]!!!  Thanks [NAME] |  |  |  |  |  |  |  | 2008-02-07 00:00:00
 |  |  |  |  | I don't like my formula yet because I've subtracted all |  |  |  |  |  |  |  | 2008-02-08 00:00:00
 |  |  |  |  | Saturdays from the timespan. |  |  |  |  |  |  |  | 2008-03-20 00:00:00
 |  |  |  |  | What if a Holiday is on a Saturday? Then I've subtracted it twice. |  |  |  |  |  |  |  | 2008-05-01 00:00:00
 |  |  |  |  | I hope the Yellow formula counts them correctly. |  |  |  |  |  |  |  | 2008-05-19 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2008-06-07 00:00:00 |  | <<These dates are on Friday.
 |  |  |  |  |  |  |  |  |  |  |  |  | 2008-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2008-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2008-10-02 00:00:00
 |  | The formula shoule be located in cell C2 |  |  |  |  |  |  |  |  |  |  | 2008-10-27 00:00:00
 |  | a) Exclude Saturday |  |  |  |  |  |  |  |  |  |  | 2008-12-08 00:00:00
 |  | b) Exclude Public Holidays - Holidays is a Named [NAME] so you can expand it. |  |  |  |  |  |  |  |  |  |  | 2008-12-25 00:00:00
 |  | c) I remove one day for each 7 but worry about the formula for less than a week |  |  |  |  |  |  |  |  |  |  | 2008-12-29 00:00:00
 |  | d) If you need it to work for days less than 7 I need to worry about Saturdays as special cases. |  |  |  |  |  |  |  |  |  |  | 2009-01-01 00:00:00
 |  | e) Any other days that need to be skipped should be put in Holidays list. |  |  |  |  |  |  |  |  |  |  | 2009-01-26 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-27 00:00:00
 |  | Kumara - Please try some sample start and end dates in column A and B |  |  |  |  |  |  |  |  |  |  | 2009-02-02 00:00:00
 |  |  | DaddyLongleggs formula is in Yellow |  |  |  |  |  |  |  |  |  | 2009-02-09 00:00:00
 |  |  | My old formula is in Orange |  |  |  |  |  |  |  |  |  | 2009-03-09 00:00:00
 |  | Do some testing to prove to yourself that the Yellow Formula is correct. |  |  |  |  |  |  |  |  |  |  | 2009-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2009-05-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2009-06-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2009-08-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2009-09-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2009-09-22 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2009-10-17 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2009-11-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2009-12-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2009-12-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2010-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2010-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2010-02-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2010-02-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2010-02-26 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2010-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2010-05-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2010-08-31 00:00:00