DAX Function Guide
TODAY

Sam McKay
CEO & Founder
How does the TODAY work?
The TODAY function (DAX) returns the current date.
TODAY Formula Syntax
TODAY (
)
How do you use the TODAY?
The TODAY function is useful when you need to have the current date displayed on a worksheet, regardless of when you open the workbook. It is also useful for calculating intervals.
Related Blog Posts
Loading
Considerations when using the TODAY?
- If you need a static date that won’t change, you can enter the current date using the keyboard shortcut Ctrl + ;
- If you need current date and time, use the NOW function.
Related Video Tutorials
Loading
Formula examples using the TODAY
=YEAR(TODAY())-1963
=TODAY()+7
=TODAY()+7
Related Courses
Loading