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.
Frequently Asked Questions
What is the DATE Function?
The DATE function is a Sourcetable function that works with dates and times. It returns serial numbers for dates and the value for the input date. Cells with date and time formulas are formatted as dates by Sourcetable.
What are the arguments for the DATE Function?
The arguments are:
- Year
- Month
- Day
