Do you need a report that calculates the number of days between two date fields?
This is a simple Crystal Formula: <Date 1> minus <Date 2>
What if you need to exclude the weekends from your calculation? This formula is a little bit more complex.
Let’s say that you require a Sales history report that shows how many days it takes to ship an order from the day we received the order until the day it is invoiced. You also want to calculate how many days early or late based on the date promised to the customer. Weekends must be excluded from the number of days since no deliveries occur on the weekends.