- SpreadJS Overview
- Getting Started
- JavaScript Frameworks
- Best Practices
- Features
- SpreadJS Designer
- SpreadJS Designer Component
- Touch Support
-
Formula Reference
- Formula Overview
-
Formula Functions
- Barcode Functions
- Compatibility Functions
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Logical Functions
- Lookup and Reference Functions
- Math and Trigonometric Functions
- Statistical Functions
- Sparkline Functions
- Text Functions
- Web Functions
- Other Functions
- RegEx Functions
- Import and Export Reference
- Frequently Used Events
- API Documentation
- Release Notes
DATE
This function returns the DateTime object for a particular date, specified by the year, month, and day.
Syntax
DATE( year, month, day )
Arguments
This function has these arguments:
Argument | Description |
|---|---|
year | Number representing the year, from 1 to 9999, using four digits; if not an integer, the number is truncated |
month | Number representing the month of the year; if not an integer, the number is truncated |
day | Number representing the day of the month; if not integer, the number is truncated |
If the month is greater than 12, then the month increments by the number of months over 12 and the year in advance, if needed. For example, DATE(2003,16,2) returns the DateTime object representing April 2, 2004.
If the day is greater than the number of days in the specified month, then the day increments that number of days from the first day of the next month. For example, DATE(2004,1,35) returns the DateTime object representing February 4, 2004.
If values for the arguments are not integers, any decimal places are truncated. Negative values for months are taken from the year in previous years. Negative values for days are taken from the month into previous months.
Data Types
Accepts numeric data. Returns a DateTime object.
Examples
DATE(A1,B1,C1)
DATE(R1C1,R1C2,R1C3)
DATE(2003,1,1) gives the result of January 1, 2003.
DATE(2004,2,10) gives the result of February 10, 2004.