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.

Comments are closed.