These update automatically when Excel updates. We probably all know that we can use the =TODAY() or the =NOW() formula to enter a date into Excel. Use TODAY and NOW Functions To Insert An Excel Timestamp. However, entering this data is usually done manually by the user and takes way too much time for us to Excel At Excel.
So, under lots of circumstances, would you enter the date on a spreadsheet for an entry onto an invoice, a project plan, etc., and you would do this by entering the current date and time.