Power Query
published
Search
⌃K

Date.AddDays

Date.AddDays

Adds the specified days to the date.
function (optional dateTime as nullable any, numberOfDays as number) as nullable any

Description

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

Category

Date

Examples

Add 5 days to the date, datetime, or datetimezone value representing the date 5/14/2011.
Date.AddDays(#date(2011, 5, 14), 5)

date(2011, 5, 19)

Last modified 4yr ago