DATE
Returns the date, given the year, month, and day of the month.
Syntax
year: The year to display in the result. Must be an integer between 1583 and 9956, or between 0 and 99. E.g. 2020
month: The month to display in the result. Must be an integer. If month value is:
0 - It subtracts the first month from the year. E.g. DATE(2017,0,2) gives December 2, 2016
Greater than 12 - It adds number of extra months to the given year. E.g. DATE(2016,13,2) gives January 2, 2017
Less than 0 - It subtracts number of months from the given year. E.g. DATE(2017,-2,1) gives October 1, 2016
day: The day to display in the result. Must be an integer. When day is:
Greater than days in the specified month, it adds number of extra days to the next month. E.g. DATE(2017,1,32) gives February 1, 2017.
0 - Subtracts the current day in the given month and year. E.g. DATE(2017,1,0) gives December 31, 2016
Examples
|
Formula |
Result |
|
=DATE(2020;1;1) |
1/1/20 |
|
=DATE(2020;1;0) |
12/31/19 |
|
=DATE(2020;15;1) |
3/1/21 |
Possible Errors
|
Errors |
Meaning |
|
#N/A! |
|
|
#NAME! |
|
|
#VALUE! |
|
|
#REF! |
|
|
#NUM! |
|
Similar Functions
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Zoho DataPrep Resources
Design. Discuss. Deliver.
Related Articles
DATEDIF
Returns the number of days, months, or years between two given dates. Syntax DATEDIF(start_date; end_date; type) start_date: Starting date for the period. E.g. "1/1/2020" end_date: Final or end date for the specified period. E.g. "2/4/2018" type: ...DATEVALUE
Returns the date-time serial number, from a date given as text. This can be formatted to read as a date. Syntax DATEVALUE(date_text) date_text: A date expressed in the form of text. E.g. "2/13/2020" Examples Formula Result ...DAYS
Returns the number of days between two given dates i.e. end_date - start_date. Syntax DAYS(end_date; start_date) end_date: The date till which you want to calculate the number of days. E.g. "7/8/2020" start_date: The date from which you want to ...WEEKS
Returns the number of weeks between two given dates. Syntax WEEKS(start_date; end_date; [mode]) start_date: The date from which to calculate the number of weeks. E.g. "2/5/2020" end_date: The date up to which to calculate the number of weeks. ...YEARS
Returns the number of years between two given dates. Syntax YEARS(start_date; end_date; [mode]) start_date: The date from which to calculate the number of years. E.g. "2/5/2020" end_date: The date up to which to calculate the number of years. ...