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.

Leave a Reply

Your email address will not be published. Required fields are marked *

*