Dave Bruns

Sometimes, dates in Excel appear as text values that are not recognized as proper dates. The DATEVALUE function is meant to convert a date represented as a text string into a valid Excel date. Proper Excel dates are more...Read more

The YEAR function extracts the year from a given date as a 4-digit number. For example:

=YEAR("23-Aug-2012") // returns 2012
=YEAR("11-May-2019") // returns 2019

You can use the YEAR function to extract a month number from a date into a...Read more

The MONTH function extracts the month from a given date as a number between 1 to 12. For example, given the date "June 12, 2021", the MONTH function will return 6 for June. MONTH takes just one argument, serial_number, which must be a valid...Read more

The DAY function returns the day component of a given date as a number between 1 to 31 from a given date. For example, with the date January 15, 2019 in cell A1:

=DAY(A1) // returns 15

You can use the DAY function to extract a day...Read more

The DATE function creates a date using individual year, month, and day arguments. Each argument is provided as a number, and the result is a serial number that represents a valid Excel date. Apply a date...Read more