I have two dates in my data: Start Date and End Date.
I would like to create a formula in Webi that calculates the number of business days (M-F) between these two dates.
Any help would be greatly appreciated. Thanks!
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"))))
It appears to be counting the weekend days still...
My dates are set like 1/1/2016, etc. There is no mention of Saturday or Sunday in the data
That worked!
Can you help me understand what is happening in this formula so that I can manipulate it for other reports if needed?
check attached link.it's well explained.