Returns number of working days (by default excluding Saturday and Sunday) from first date to second date.

Syntax

DateDiffWorkdays(from_date, to_date)
DateDiffWorkdays(from_date, to_date, nonworkdays)
CODE

Arguments

from_date

MDX expression that returns a date. Starting date that, if it is workday, will be included in calculation.

to_date

MDX expression that returns a date. Date until which to count workdays; this day itself will not be included in calculation even if it is workday.

nonworkdays

Specify string with non-working day numbers (use 1 for Monday, 2 for Tuesday, 3 for Wednesday, 4 for Thursday, 5 for Friday, 6 for Saturday, 7 for Sunday).

If not specified then '67' is used which means Saturday and Sunday.

Examples

Following example returns the number of working days in the current month (days from Monday to Friday)

(DateDiffWorkdays(
  [Time].CurrentMember.StartDate,
  [Time].CurrentMember.NextStartDate,
'67'))
CODE

See also