Using TODAY() to automatically update your spreadsheet dates

This is a relatively straight forward formula.

TODAY()

By putting this formula in a cell, the cell will display the current date. Therefore, It updates automatically everyday.

Some useful application:

Number of days between today and 25/05/06:

Assuming cell B1 =TODAY()

=DAYS360(“25/05/06,B1)

The above formula works out the number of days between current date and 25/05/06. Therefore, if today is 29/05/06, the result will be 4.

Keywords: Time, Date