The DATE function in Microsoft Excel takes a number and returns the corresponding date. The number can be in any of the following formats: yyyy-mm-dd, yyyy/mm/dd, mm/dd/yyyy, or dd/mm/yyyy.
DATE is a function in Excel that takes in a date as an input and outputs the date in a standard format. The syntax for DATE is DATE(year,month,day). For example, if you wanted to output the date January 1, 2019, you would use the syntax DATE(2019,1,1).
In Excel, the DATE function can be used to return the date corresponding to a given year, month, and day. For example, the following formula would return the date "July 4, 2019":
There are a few instances when you should not use DATE in Excel. One instance is when you are trying to compare two dates and determine whether or not they are the same. In this case, you should use the DATEVALUE function, which will return the date serial number for a given date. Another instance is when you are trying to calculate the number of days between two dates. In this case, you should use the DAYS function, which will return the number of days between two dates.
DATE is short for date. It is a formula that calculates the day of the month from a supplied year and month. The date formula is =DATE(year,month,day).
There are a few similar formulae to DATE in Excel. The DAY function calculates the day of the week from a supplied date. The DAYS360 function calculates the number of days between two dates, taking into account leap years. The NETWORKDAYS function calculates the number of working days between two dates.