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 update automatically when you [...]