How do I calculate the difference in days between two dates I don't want ca

Date-math can be done directly.

For example, =date(2015,7,31)-today()) returns '21' ( the number of days between today (10 July) and 31 July 2015)

You may have to wrap the function in "tointeger()" for formatting purposes, but the general idea is that it can be done directly where 1=one day. You can also use fractions for partial days (i.e. 1/24=.0416=one hour)

Date-math can be done directly.

For example, =date(2015,7,31)-today()) returns '21' ( the number of days between today (10 July) and 31 July 2015)

You may have to wrap the function in "tointeger()" for formatting purposes, but the general idea is that it can be done directly where 1=one day. You can also use fractions for partial days (i.e. 1/24=.0416=one hour)