DATE function - The date function in Excel
From numbers in different cells, or returned from the MONTH (), DAY (), YEAR () functions, and you want to give the dates in the standard format corresponding to the numbers you enter . The DATE () function will help you do that.
The following article describes the syntax and usage of the DATE () function in Excel.
Description
The DATE () function returns a date that is formatted corresponding to the date entered as based on the date index.
Syntax
= DATE (year, month, day)
Inside:
- year: is the year index number, it can include from 1 to 4 digits (0 ~ 9999), depending on the date system that the computer is using. In Windows operating systems, by default Microsoft Excel uses the 1900 date system.
+ If year is greater than 0 and less than or equal to 1899 then Excel will automatically add 1900 to calculate.
+ If year is from 1900 to 9999, Excel will use that number as the year to calculate.
+ If year is less than 0 or greater than or equal to 10000, Excel will report the #NUM! Error.
- month: is the number representing the month of the year from January to December, it can be negative or positive integers.
+ If month is greater than 12 then Excel will convert to 12 equals a year and increase the number of years.
+ If month is less than 1, then Excel will convert -12 by 1 year and reduce the number of years.
- day: is the number representing the day from 1 to 31 can be a positive integer or a negative integer.
+ If day is greater than the number of days of the month, Excel will convert it to the largest number of days of the month accordingly and increase the number of months, if the number of months is greater than 12 months, the number of years is also increased.
All arguments are required, the arguments can be specific numbers or they may be formulas.
For example
With short syntax and simple usage, you will easily remember and use the DATE () function in Excel. In addition, you need to remember that when entering the function, the arguments must be entered in the same order as year, month and day (year, month, day). Good luck!
You should read it
- EDATE function - Add and subtract months to a specified date in Excel
- NOW function - The function returns the current date and time in Excel
- COUPNCD - The function returns the next coupon date in Excel
- How to use the WORKDAY function in Microsoft Excel
- The WORKDAY.INTL function - The function returns a date before or after the date starting with a custom weekend in Excel
- How to use the SUMIF function in Excel
- The WORKDAY function - The function returns a date before or after the start date of a number of working days in Excel
- TODAY function - The function returns the current date value in the format in Excel
May be interested
- How to fix date errors when copying to another Excel filewhen you copy the date to another excel file or change the date, it is 4 years and 1 day slower than the date in the file. so how to fix the error of displaying the wrong date when copying in excel?
- TODAY function - The function returns the current date value in the format in Exceltoday function - the function returns the current date value in the format in excel. the today () function does not automatically update, but requires setting changes to control.
- The WORKDAY.INTL function - The function returns a date before or after the date starting with a custom weekend in Excelworkday.intl: the function returns a date before or after the start date of a specified number of working days with a custom weekend. the weekend parameter indicates which day and how many days. syntax: workday (start_date, days, [weekend], [holidays])
- WEEKDAY function - The function returns the weekday of a corresponding date in Excelweekday function: the function returns the weekday of a corresponding day. the return value is an integer between 1 (sunday) and 7 (saturday). syntax: weekday (serial_number, [return_type])
- How to automatically update the Excel file editing timewhen inserting and editing time excel file, you will control the latest time to edit the file if shared with many people.
- Basic Excel functions that anyone must knowthe basic functions in excel such as the excel function, the excel statistics function we summarized below will be very helpful for you who often have to work on excel spreadsheets, especially in the field of accounting. let's refer to offline.
- The DAY function - The function returns the day of the day, month and year in Excelthe day function: the function takes a date value from a date value. the return value is an integer between 1 and 31.
- The WORKDAY function - The function returns a date before or after the start date of a number of working days in Excelworkday - the function returns a date before or after the start date of a specified number of working days. weekends and public holidays do not count toward business days. syntax: workday (start_date, days, [holidays])
- Date time functions in Excelexcel supports you to process and calculate quickly with the functions that excel provides such as calculation functions, date functions ... one of them is the function of time to help you handle the prices. time value: hour, minute, second conveniently
- How to use Hlookup function on Excelhlookup function basically also has the function syntax and features like vlookup function, which is to help users find data in excel table, with the conditions or given information. here is the guide for using the hlookup function in detail.