Results 1 to 2 of 2
Thread: Calculating Business Days
2001-05-29, 20:36 #1AsmarGuest
Calculating Business Days
Guys & Gals,
I'm working a project and need to calculate business days from two dates, start date and end date. The dates already reside in s spreadsheet. Is there a formula or macro that will provide this info without manually counting the days??
Pls respond privately firstname.lastname@example.org
2001-05-29, 22:27 #2
- Join Date
- Dec 2000
- Queanbeyan, New South Wales, Australia
- Thanked 0 Times in 0 Posts
Re: Calculating Business Days
Yep, there's a function to do it. First, you need to install the Analysis toolpack (Tools, Addids, Analysis toolpack). Then use the formula "=networkdays(startdat,enddate[,holidays])"Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.