Weekdays

[CPK6104]

I'm sure this has been asked a million times but I can't seem to find the asnwer. Here's goes one million and one...

I'm calculating the number of days it takes to deliver a document based on a requested date and delivery date:

DateDiff ("d",{Date_Requested},{Date_Delivered})

Is there a way to exclude Saturday's and Sunday's so that I'm only including weekdays (when the time to deliver spans a weekend)?

Thank you for your help.

 

[MCuthill]

CPK6104,

The solution to your question can be found at Ken Hamady's website.

Link to Number of Work Days between two dates

Cheers!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."

 

[CPK6104]

Thank you!