Skip to Content
avatar image
Former Member

How to calculate the number of BUSINESS days between two dates

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Feb 06, 2017 at 06:55 PM

    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/

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 06, 2017 at 06:37 PM

    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
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 06, 2017 at 06:48 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 06, 2017 at 06:58 PM

    That worked!

    Can you help me understand what is happening in this formula so that I can manipulate it for other reports if needed?

    Add comment
    10|10000 characters needed characters exceeded