try this.
=Floor((DaysBetween([Start Date];[End Date]))-Truncate((DayNumberOfWeek([Start Date])+DaysBetween([Start Date];[End Date])) /7 ;0)*2)+1
also check this.
http://www.dagira.com/2009/10/23/calculating-business-days-between-two-days-via-report-functions/
use this formula.
=DaysBetween([Start Date] Where (Not(DayName([Start Date]) InList("Saturday";"Sunday")));[End Date] Where (Not(DayName([End Date]) InList("Saturday";"Sunday"))))
Add comment