In yesterday's post I showed formulas you can use to pull information from a date in Excel. In some workbooks you'll enter dates manually, but often you'd like a date to be calculated automatically.

Calculate the Current Date

To show the current date in a cell, use the TODAY function:

  =TODAY()

This date will [...]