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:
All-in-one knowledge management and training platform for your employees and customers.
Create. Review. Publish.
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
Design. Discuss. Deliver.
Related Articles
What are all the cell formats available in Zoho Sheet?
Zoho Sheet supports the following cell formats: General Number Accounting Currency Date Time Percentage Fraction Scientific Text Regional And custom made formats.CURRENT
Returns the current (to date) result of a formula. It can be used in combination with other functions. For example, the function =2+3+CURRENT() returns 10 as the result. Syntax CURRENT() Examples Formula Result ="co"&CURRENT() coco ...GETPIVOTDATA
Extracts specific values from the pivot table. Syntax GETPIVOTDATA(data_field; pivot_table; [field_1; item_1; field_2; item_2];...) data_field: The name of the value field in the pivot table that contains the data you wish to extract. This should be ...Filter data in pivot tables based on dates with timeline
What is a timeline? Timeline allows you to filter data in your pivot tables based on dates quickly. To add a timeline to your spreadsheet, there should be a pivot table with a date range. How to add a timeline Right-click the pivot table and select ...Keeping track of the changes made to the spreadsheet
What is version history? Zoho Sheet automatically saves all previous versions of your spreadsheet. You can visit, revert or download any previous versions of the spreadsheet at any given point of time. View all the previous versions of a sheet To ...