Date.AddDays is a function in the Power Query M language that adds a specified number of days to a date or datetime value. The resulting value is returned as a date, datetime, or datetimezone.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365


   dateTime as any,
   numberOfDays as number,
) as any


Returns the date, datetime, or datetimezone result from adding numberOfDays days to the datetime value dateTime.

  • dateTime: The date, datetime, or datetimezone value to which days are being added.
  • numberOfDays: The number of days to add.


Add 5 days to the date, datetime, or datetimezone value representing the date 5/14/2011.

// Output: #date( 2011, 5, 19 )
Date.AddDays( #date( 2011, 5, 14 ), 5 )

Learn more about Date.AddDays in the following articles:

Other functions related to Date.AddDays are:

BI Gorilla Blog

Last update: August 25, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation:
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.