The TODAY function returns the serial number of the current date without the time information. The return value gets updated with every recalculation. In this guide, we’re going to show you how to use the TODAY function and also throw in some tips and error handling methods.
Supported versions
- All versions
Syntax
TODAY()
Arguments
- No arguments
Examples
Tips
- Excel stores dates as serial numbers. Excel assumes the date 1/1/1900 as 1 and increases this number by 1 for each day. For example; 12/31/2018 is equal to 43465. Because of this situation, avoid to use dates as text although the DAY function can operate with dates match with your local format. Use DATE function to generate Date
- Use number format options to display only specific part of a date-time value. For example;
- "mmm-yy" to display month name with a 2-digit year: Jan-19
- "ss" to display only seconds: 28
- More options can be found in Number Formatting in Excel – All You Need to Know
- Use plus (+) and minus (-) operators to add/remove days to current time: How to use day information from date data in Excel
- To retrieve the time value as well as the date use the NOW
