Calculating activity duration on excel 2007

[Totty]

Good evening
I wanna calculate the duration of an activity using excel 2007, the activity starts on 2/1/2010 and finishes on 9/1/2010 where Friday is a weekend , 7/1/2010 and 19/1/2010 are holidays.Hint duration equation = (finish-start)+1
Best Regards

 

[DRSteele]

I think they built the function NETWORKDAYS.INTL for this very purpose. [I am unsure whether or not it works in 2007.]

 

[Totty]

Hi
Unfortunately excel 2007 doesn't has the NETWORKDAYS.INTL function
Would u pls post the formula to calculate the duration using NETWORKDAYS.INTL in excel 2010
Regards,