DAX Function Guide

TODAY
Empty image or helper icon

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