How to insert the current date or time

Example 1

The first way is to write date right into the cell or to use the shortcuts:

Ctrl+; enters the current date.

Ctrl+: enters the current time.

This method ensures that the cell will always has the date which you have written into it.

Example 2

If you need date changing always to current, you have to use Date & Time functions.

Date functions on the Ribbon


To insert the current date use the function TODAY(). To insert the current date and time use the function NOW(). These functions do not require any arguments.

Copyright © All Rights Reserved · Green Hope Theme by Sivan & schiy · Proudly powered by WordPress