All eazyBI for Jira eazyBI for Confluence Private eazyBI


EAZYBI Returns date plus specified number of workdays.


DateAddWorkdays(date, days)
DateAddWorkdays(date, days, nonworkdays)


dateDate expression.

Integer expression for number of working days to add.

By default Saturdays and Sundays are considered as non-working days.


Specify string with non-working day numbers (use 1 for Monday, 2 fort 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.

If Time dimension options are specified then these Time dimension non-working days will be used (in this case please do not specify this argument).


DateAddWorkdays([Issue].CurrentMember.get('Created at'), 5)

DateAddWorkdays([Issue].CurrentMember.get('Created at'), 5, '67')

The example below calculates predicted date to complete unresolved issues based on recent progress in the project

  -- remaining scope
  ([Measures].[Issues due],
  -- average resolved issues per week in last 52 weeks
	 ([Measures].[Issues resolved],
  * 5  -- workdays in week 

See report example Predicted completion date in our Demo account. The calculated measure Rolling predicted date uses the formula above to calculate a date in how many days from today unresolved issues will be resolved if the progress will be similar to the last 52 weeks and no new issues will come in. Remaining scope / average pace per week gives a count of predicted weeks. They are multiplied by 5 workdays per week to get total predicted workdays that could be added from Today.

See also