How to use Excel's DATE, DATEVALUE, MONTH, YEAR and DAY functions

Following video demonstrates the usage of Excel's Date functions:

• DATE() : Takes year, month and day as parameters and returns Excel date value.
• DATEVALUE(): Takes date string as parameter and returns Excel date value.
• YEAR(): Takes Excel date value as parameter and returns corresponding year number (1900..9999).
• MONTH(): Takes Excel date value as parameter and returns corresponding month number (1..12).
• DAY(): Takes Excel date value as parameter and returns corresponding day number (1..31).

If you are unfamiliar with Excel's way to handle dates, please check Excel Date System basics.