Here's our Microsoft Office Tip for.. December 7, 2004
Click Here to see a complete list of all of our previously released Tips!
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.