Date.AddWeeks
Moves a date, datetime or datetimezone by whole weeks, seven days each.
Group: Dates and times. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Date.AddWeeks(dateTime as any, numberOfWeeks as number) as any| Parameter | Type | Description |
|---|---|---|
dateTime | any | The date, datetime or datetimezone to move; null gives null. |
numberOfWeeks | number | How many weeks to move: negative goes back in time. |
Returns
any. The same kind of value as given, moved by that many weeks.
Remarks
- A date gives a date, a datetime a datetime, a datetimezone a datetimezone with its offset unchanged; the time of day is kept.
- The weekday stays the same: a Friday moved by weeks is a Friday.
Examples
A follow-up two weeks after a sale
Date.AddWeeks(#date(2024, 3, 15), 2)#date(2024, 3, 29)Four weeks back
Date.AddWeeks(#date(2024, 3, 15), -4)#date(2024, 2, 16)