Introduction
The TODAY and NOW functions help you get the current date and time automatically in your spreadsheet. They update every time you open or change the sheet, so you always see the latest date or time without typing it manually.
When you want to show today's date on a report or invoice automatically.
When you need to track the current time for a time log or attendance sheet.
When calculating how many days have passed since a certain date.
When creating a deadline countdown that updates every day.
When stamping the current date and time for data entry records.