Returns the current date. Essential for date calculations, age calculations, and creating dynamic date-based reports in Excel.
Master the fundamentals of Excel TODAY function
The TODAY function is Excel's date function that returns the current date as a serial number. It's essential for date calculations, age calculations, and creating dynamic date-based reports that automatically update.
Returns the current date without parameters
Updates automatically when worksheet recalculates
Returns date as Excel serial number
Essential for date arithmetic
Function-specific parameters
Function-specific return type
Calculate age from birth date
Track days since events
Generate date-stamped reports
Implement date-based business rules
Exact matching required
Returns numeric position
Handles missing text gracefully
=TODAY()Current date as a serial number
Description: Returns the current date
Display current date
Returns the current date without any parameters
Simple VBA implementation of TODAY function
' Basic TODAY in VBA
Range("A1").Value = Date
' Using VBA TODAY function
Dim currentDate As Date
currentDate = Date
' Loop through range and insert current date
Sub InsertCurrentDate()
Dim cell As Range
For Each cell In Range("A1:A10")
cell.Value = Date
Next cell
End SubCalculate age from birth date
Track days since events
Generate date-stamped reports
Implement date-based business rules
TODAY returns serial number instead of formatted date
=TODAY()Solution: Format the cell as a date to display properly
TODAY doesn't update automatically
=TODAY()Solution: Check if automatic calculation is enabled in Excel options