| Understanding Date Arithmetic
Most applications store dates as an integer and time as a decimal value. As a result, you can use simple calculations to produce date- and time-specific values. For instance, to learn the number of days between two dates, you could use the simple formula enddate - startdate In a similar manner, you could return a date in the future by adding a value to a date in the form startdate + days Since one of your formula references contains a date, you may need to format the cell containing the above formula as a Number cell to display the actual value.  |
