← Back to Date functions

Date.AddDays

This function calculates and returns the date, time, or timezone after adding a specified number of days to a given date and time value. The input parameters include the initial date and time value, a...

Syntax

Date.AddDays(dateTime as any, numberOfDays as number) as any

About

This function calculates and returns the date, time, or timezone after adding a specified number of days to a given date and time value. The input parameters include the initial date and time value, as well as the number of days to be added.

Explanation

Increase the value of the date, datetime, or datetimezone by 5 days starting from 5/14/2011. Use Power Query function MDate.AddDays with the input date as #date(2011, 5, 14) and the number of days to add as 5. This operation will result in the output date as #date(2011, 5, 19).