DATE
Formulas / DATECreates dates from inputting a year, month, and day
=DATE(year,month,day)
- year - a number for the year
- month - a number for the month
- day - a number for the day
Examples
=DATE(1999,1,1)The function is used to create a date from separate year, month, and day values, and returns the date of January 1, 1999.
=DATE(A1,4,15)It can also be used to create dates from cell references. This example, returns the date of April 15, 2018.
=COUNTIF(range,">"&DATE(A1,B1,C1))The function can also be used to count dates greater than a certain date in a worksheet. This example, counts dates greater than January 1, 2019 in a worksheet where A1, B1, and C1 contain year, month, and day values.
=DATE(YEAR(TODAY()),1,1)The function can be combined with other functions to return the first day of the current year, and returns the first day of the current year.
Summary
The DATE function in Sourcetable allows users to turn three numbers into a date, returned as a serial number that represents the date in the 1900 date system.
- The DATE function returns a date from year, month, and day components and can assemble dates that change dynamically based on worksheet values.
- The DATE function is the safest way to create a date because it uses numerical year, month, and day values, rather than text representations.
- Use the EDATE and EOMONTH functions if you want to move existing dates forward or backward in time.
- The DATE function returns a serial number instead of a formatted date and only accepts numbers as input. If you give the DATE function text as input, it throws a #VALUE error.
Need help with Formulas?
Frequently Asked Questions
What is the DATE Function?
What are the arguments for the DATE Function?
- Year
- Month
- Day
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.