The TODAY Function in Excel returns the current date in a selected cell. This returned date updates as a spreadsheet is opened or modified. You can press F9 to recalculate the spreadsheet. Lets look at the Syntax for the TODAY Function.


 =TODAY () 

The TODAY Function has no arguments. You can add and subtract from the returned date.

TODAY Function Usage Example:

Review the example below.

Today Function
Today Function

You can format the returned date for using the Format Cells feature in Excel.

Format Cells

Need the current Date and Time, you can use the NOW Function.

Leave a Reply

FLOOR Function

The FLOOR function in Excel rounds a given number down to the nearest specified multiple. Unlike the MROUND function, the

Read More »
Scroll to Top