From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using the DATE, YEAR, MONTH, DAY, TIME, HOUR, MINUTE, and SECOND functions

Using the DATE, YEAR, MONTH, DAY, TIME, HOUR, MINUTE, and SECOND functions

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Using the DATE, YEAR, MONTH, DAY, TIME, HOUR, MINUTE, and SECOND functions

“

- Excel has numerous functions for dealing with dates and times, and although less frequently used than other functions, there are functions called Date, Year, Month, Day, and also correspondingly, Time, and Hour, Minute, Second. So, and in this worksheet called Date Year Month Day Minute didn't have room for any more there, can only have 31 characters in a range name. Let's imagine you might have a list consisting of some years, some months, some days, and you want to construct a date, or in other words, create a date right here. We can do this with the function called Date. =date, get the year, in this case it's in cell A2, comma, we get the month, it's in cell B2, comma, and the day is in cell C2, complete the entry and we've got a date there. In some situations, when you've got a list of years and months and dates, you might want to turn them all into the first day of the month, in that case here, instead of putting in the day entry coming out of column C here, you could just put…

Contents