Erik_Robinson

Thanks very much Michael, that sorted it !

Hi Thanks for that, but I need to know the days between each date so that I can see trends and patterns which occur during different seasons.

Hi, any help would be appreciated with this. I have records of jobs i do for customers, I am trying to find a way to work out the average days between each job we do ( to predict when they will need us next). At present I have a list of jobs with dates i.e. 1/1/10 Purchased 500 gallons 7/1/10 Purchased 500 gallons 18/1/10 Purchased 600 Gallons etc... What I am after is something like: 1/1/10 Purchased 500 gallons 7/1/10 (6 Days) Purchased 500 gallons 18/1/10 ( 11 days) Purchased 600 Gallons The date used is the creation date of the job record. Many thanks for looking.