From the course: Excel Business Intelligence: Power Pivot, DAX and Data Modeling

Unlock this course with a free trial

Join today to access over 24,000 courses taught by industry experts.

Basic date and time functions

Basic date and time functions - Microsoft Excel Tutorial

From the course: Excel Business Intelligence: Power Pivot, DAX and Data Modeling

Start my 1-month free trial Buy for my team

Basic date and time functions

“

All right. Next up, we've got basic date and time functions. I'm going to kind of breeze through these because all of these should look very familiar. Most are pretty much identical to their Excel formula counterparts. And we've covered a lot of these in the Power Query section of the course, anyway. So just to cover quickly, you've got your component metrics like DAY, MONTH, YEAR. Syntax-wise, you just point it to a column containing a date. Then you have your time-specific versions of those, your HOUR, MINUTE, and SECOND. Same deal. You just point it to a column containing a datetime specific value. Of course, you've got TODAY and NOW, the two volatile functions. Those return the current date or the exact time, respectively. And syntax-wise, there really is no component to those formulas. It's as simple as open and closed parentheses. And then WEEKDAY/WEEKNUM. These will give you a weekday number by default starting on Sundays or the week number of the year. And in this case, you've…

Contents