Date.AddDays
Moves a date, datetime or datetimezone forward or back by a number of days.
Group: Dates and times. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Date.AddDays(dateTime as any, numberOfDays as number) as any| Parameter | Type | Description |
|---|---|---|
dateTime | any | The date, datetime or datetimezone to move; null gives null. |
numberOfDays | number | How many days to move: negative goes back in time. |
Returns
any. The same kind of value as given, moved by that many days.
Remarks
- A date gives a date, a datetime a datetime, a datetimezone a datetimezone with its offset unchanged; the time of day is kept.
- Months and years roll over as needed.
Examples
A payment due 30 days after the invoice
Date.AddDays(#date(2024, 3, 15), 30)#date(2024, 4, 14)The day before the first of March
Date.AddDays(#date(2024, 3, 1), -1)#date(2024, 2, 29)2024 is a leap year: the day before 1 March is 29 February.
The time of day stays
Date.AddDays(#datetime(2024, 3, 15, 14, 30, 0), 2)#datetime(2024, 3, 17, 14, 30, 0)