ZoHo Creator Database newby Question

ZoHo Creator Database newby Question

Hello ZoHo Community,

Can someone help me out with my first ZoHo Creator Database?

I created a database with a form to submit data on a date base. The data entry consists of 4 columns.

For example:

Date            Value1  Value2  Value3  Value4
01-01-2016      10         15         20        10
11-01-2016      20         20         30        50

I would like to calculate the difference in values on a daily base, based on the datevalues in the Date column.
Based on the example above the avarage daily value for Value1 is 1 ((20-10)/10))

How can I count the number of days between 2 Date values in the Date column?

Many thanks in advance.

Regards,

Wilco