How to use the TODAY function
in Excel

Date.AddDays is a great function that allows us to add days onto a column of Date or DateTime values in the PowerQuery editor. Adding days onto a date value isn’t something that you can do through PowerQuery’s user interface. However, because it’s quite a simple function to use, it’s a great starting point for learning M code.

In the video above I show how this function can be used to create a payment due date column in an accounts payable report where we only have an invoice date column. We could use the same function for an Account Receivable report to show when we’re expecting cash in. Both together would be really useful for a cashflow forecast!

Play Video

If you’d like to follow along with the video, then download the Excel file in the link to the right, and connect Power BI or PowerQuery in Excel to the file:

A little bit about the function...

Syntax, returned values and related functions

The syntax for the TODAY functions is as easy as you can get. There are NO parameters!


Can’t get easier than that eh?

All you need to do to get this function to work is type the above syntax in a cell of Excel and hit return. The cell will return the current date and then every time the workbook is opened, the cell will update to the current date.

Other useful Info and links

 – If you’d like to visit the Microsoft M Code library then click here