DATE allows you to have the month, day and year is separate columns and then concatenate the date into the date format that you choose. If you have a situation where you are given data with the months, days and years in separate columns (or if you parsed the dates by month, day and year to evaluate or change the data) we‘ll use the DATE formula to put the month, day and year into the date format of our choosing. Syntax: DATE(year, month, day)