← Back to Date functions

Date.AddWeeks

This function calculates the new date, datetime, or datetimezone value that is obtained by adding a specified number of weeks to a given date, datetime, or datetimezone value. The parameter "dateTime"...

Syntax

Date.AddWeeks(dateTime as any, numberOfWeeks as number) as any

About

This function calculates the new date, datetime, or datetimezone value that is obtained by adding a specified number of weeks to a given date, datetime, or datetimezone value. The parameter "dateTime" represents the original date/time value, while the parameter "numberOfWeeks" specifies the number of weeks to be added.

Explanation

Increase the date value of 5/14/2011 by 2 weeks using Power Query function MDate. Syntax: MDate.AddWeeks(#date(2011, 5, 14), 2) Result: #date(2011, 5, 28)