Introduction
The DATE function helps you create a date by combining year, month, and day numbers. This is useful when you have separate numbers and want to see them as a proper date in your spreadsheet.
When you have year, month, and day in separate cells and want to combine them into one date.
When you want to create a date for a report or calendar from numbers you typed or calculated.
When you need to fix dates that are split into parts so Excel can recognize them as dates.
When you want to calculate the difference between dates created from parts.
When you want to sort or filter data by dates created from separate year, month, and day values.