Crystal Reports – number of working days between two dates

To find the number of working days between two dates (not including public holidays unfortunately), the formula to enter is

Datediff(“d”, startdate, enddate) – Datediff(“ww”, startdate, enddate, crSaturday) – Datediff(“ww”, startdate, enddate, crSunday)

To find out more about our Crystal Reports training Sydney, Australia, please visit http://www.jmdtraining.com.au/it-training/crystal-reports-training.

To find out more about our Crystal Reports training London, England, please visit http://www.jmdtraining.co.uk/it-training/crystal-reports-training.

About jdonbavand

I am a trainer of Microsoft Office, Microsoft Project and Crystal Reports. I have called my blog "If Only I'd Known That...." because I hear it so many times in training sessions. In fact, if only I had a £100 (or 150 Aussie dollars)for every time someone says "If only I'd known that." ....
This entry was posted in Crystal Reports. Bookmark the permalink.

One Response to Crystal Reports – number of working days between two dates

  1. Seb syko says:

    Hi, thnks a lot.
    Had to make changes cause of the language use, so if someone else try, watch for the ” ” and the – (minus). I still need to figure out why it miss 1 day, i have to do +1 to have the exact working days.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s