How to use the TODAY function
The TODAY function returns the Excel date (serial number) of the current date.
Warning! This function is volatile meaning it recalculates every time the workbook recalculates.
This may slow down your workbook calculations considerably if there are many formulas that depend on the TODAY function.
Excel Function Syntax
TODAY()
Arguments
The TODAY function has no arguments
Comments
The Excel date the TODAY function returns is a serial number that Excel recognizes and can be filtered, sorted and used in other date calculations.
Excel dates are actually serial numbers formatted as dates, 1/1/1900 is 1 and 2/2/2018 is 43133. There are 43132 days between 2/2/2018 and 1/1/1900.
You can try this yourself, type 10000 in a cell, press CTRL + 1 and change the cell's formatting to date, press with left mouse button on OK. The cell now shows 5/18/1927.
'TODAY' function examples
This article demonstrates a formula that returns a date based on a week number and a weekday like Sun to […]
This article describes how to build a calendar showing all days in a chosen month with corresponding scheduled events. What's […]
This workbook contains two worksheets, one worksheet shows a calendar and the other worksheet is used to store events. The […]
Functions in 'Date and Time' category
The TODAY function function is one of many functions in the 'Date and Time' category.
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form