Calculating days between dates and average times

[Antroj]

Hi

I am trying to write a formula which will calculate the number of days between two specific dates and then calculate the average, for example:

Start Date: 01/04/2009
End Date: 19/05/2009
What is the total number of days between the start date and end date?
When applied to a list of data, what is the average number of days?

Thanks

 

[Madawc]

DateDiff will give you the number of days between two dates. If you write a formula field finding this for each record, you could then get the average using a Summary Total. If you're not already familiar with Crystal's automated totals, see FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP