TODAY
Returns the current date.
Syntax:
=TODAY()
Example:
=TODAY()
Result: Current date
NOW
Returns the current date and time.
Syntax:
=NOW()
Difference
|
Function |
Returns |
|
TODAY() |
Current Date |
|
NOW() |
Current Date + Time |
Practice
Create a worksheet with:
|
Item |
Formula |
|
Today’s Date |
=TODAY() |
|
Current Date & Time |
=NOW() |