- Document Solutions for Excel, .NET Edition Overview
- Key Features
- Getting Started
- Features
- Templates
- Formula Reference
- File Operations
- Document Solutions Data Viewer
- API Reference
- 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 | [Required] Number representing the year, from 1 to 9999, using four digits; if not an integer, the number is truncated |
month | [Required] Number representing the month of the year; if not an integer, the number is truncated |
day | [Required] Number representing the day of the month; if not an 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.
Examples
DATE(A1,B1,C1)
DATE(R1C1,R1C2,R1C3)