1 Reply Latest reply on Mar 2, 2011 6:08 PM by James Baker

    DATEDIFF calculation excluding weekends

    Jeff Harding

      I have a calculated field that shows the number of days between 2 dates and excludes the weekends. The problem is that it's not showing the correct number of days when going from one year to the next. ie. December 30, 2010 to January 3, 2011. It shows 106 days between the two dates. It works fine when calculating in the same year. ie. January 5, 2011 to January 21, 2011. It shows 12 days.

      Here is the formula:

      DATEDIFF("weekday",[RecDate],[DateOff])-2*(DATEPART('week', [DateOff]) -DATEPART('week', [RecDate]))

      Below is an attachment of some results I get..