Counting number of days less weekends.

I want to count the number of days between two dates. I am currently using this formula:

Please Login or Register  to view this content.

where B1 is equal to a date.

I want to modify the code to exclude weekends and, if possible, holidays. I don't really care if it excludes holidays but if it can be done great. So for example if:

2/1/08 = Friday
2/2/08 = Sat
2/3/08 = Sun
2/4/08 = Mon
2/5/08 = "today"

then today()-2/1/08 should equal 2 days.

Thanks for any help.

I like the solution but I can't use it. Our company won't allow users to install add-ins and we don't have admin rights. Any other solutions? Thanks

Looking for a different type of formula. In column A1 is a date...say 2/29/2008. In column B1 is another date...say 2/19/2008. In column C1 I want to calculate the number of days between the A1 and B1. A simple formula to calculate exact number of days would return 10 days. If I exclude Saturdays and Sundays then formula should return value of 8.

I have attached a spreadsheet of desired results which is in column E to exclude weekends. Column F would exclude weekends and holidays (holiday list is in column H). I prefer a formula to recreate the results in Column F.

Thanks again for any help.

assuming the dates in column B will always be workdays you can use this formula in E3 copied down to exclude weekends

=SUM(INT((WEEKDAY(B3-{2,3,4,5,6})+A3-B3)/7))-1

and this formula in F3 to exclude weekends and holidays

=SUM(INT((WEEKDAY(B3-{2,3,4,5,6})+A3-B3)/7))-SUMPRODUCT((B3<=H$3:H$5)*(A3>=H$3:H$5)*(WEEKDAY( H$3:H$5,2)<6))-1

Note: if you ever upgrade to Excel 2007 you should be able to use NETWORKDAYS as it's an inbuilt function in that version