Introduction
The TODAY and NOW functions help you add the current date or date and time to your spreadsheet. They update automatically every time you open or change the sheet, so you always see the current day or exact time.
When you want to show today's date on a report or invoice automatically.
When you need to track the exact time a task was completed.
When you want to calculate how many days have passed since a certain date.
When you want to stamp the current date and time on a form submission.
When you want to create a dynamic dashboard that updates daily.