Learn the DATE function to create dates from year, month, and day values. Essential for date calculations and dynamic date generation.
Syntax
DATE(year, month, day)Parameters
yearThe year (1-4 digits, 1900-9999)
monthThe month (1-12, can exceed for date math)
dayThe day (1-31, can exceed for date math)
Examples
=DATE(2024, 1, 15)Creates January 15, 2024
=DATE(YEAR(A1), MONTH(A1)+1, 1)First day of next month
=DATE(2024, 13, 1)Returns January 1, 2025 (month overflow)
Common Errors
#VALUE! - Non-numeric arguments
#NUM! - Year out of range
Pro Tips
Month/day values can exceed normal ranges for date math
Use with YEAR, MONTH, DAY to manipulate dates
Combine with EOMONTH for end-of-month dates
Need Help with DATE?
Describe your specific use case and our AI will generate the perfect DATE formula for you.
Generate DATE Formula