Date Difference for weekdays only

[Web2CRM]

Hi Cognos Gurus,

I need some help on date calculation between two dates but I need to exclude weekends in the calculation result.

I used the _days_between ([Date1],[Date2]) to get the date difference, I am not sure how to exclude weekends.

ex: March 10, 2014 and March 17, 2014 - the result should be 5 (weekends not included)

Thanks in advance...

[BigChris]

Calculate the number of weeks between the two dates and subtract 2 * that number of days from your original calculation

[Ammus1234]

This may help. http://www-01.ibm.com/support/docview.wss?uid=swg21342343

[Web2CRM]

Ammus1234,

The syntax in the link you provided was perfect.. Thanks a lot guys!!!