Current Date & Time in Excel
To show the current date & time whenever a spreadsheet is opened use NOW()
Enter “=NOW()” in to the cell where you want the date and time to show press enter and there it is.
If you just want the date then use “=TODAY()”
But remember these functions will show the current date and time, so tomorrow the date and time will have changed.
