Power Query
published
Search
⌃K

Date.AddWeeks

Date.AddWeeks

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

Description

Returns the date, datetime, or datetimezone result from adding numberOfWeeks weeks to the datetime value dateTime.

Category

Date

Examples

Add 2 weeks to the date, datetime, or datetimezone value representing the date 5/14/2011.
Date.AddWeeks(#date(2011, 5, 14), 2)

date(2011, 5, 28)