Date.AddDays

Date

Adds a specified number of days to a date value.

Syntax

Date.AddDays(dateTime as any, numberOfDays as number) as any

Parameters

Name	Type	Required	Description
`dateTime`	`any`	Yes	The date, datetime, or datetimezone value to add days to.
`numberOfDays`	`number`	Yes	The number of days to add. Use negative values to subtract days.

Return Value

any — The date resulting from adding the specified number of days to the input date.

Remarks

Date.AddDays adds or subtracts a whole number of days from a date, datetime, or datetimezone value. Passing a negative numberOfDays subtracts days. The return type matches the input type.

Examples

Example 1: Add 30 days to each OrderDate

Table.AddColumn(
    Table.SelectColumns(
        Table.FirstN(Sales, 5),
        {"OrderID", "OrderDate"}
    ),
    "DueDate", each Date.AddDays([OrderDate], 30), type date
)

Result

	OrderID	OrderDate	DueDate
1	1	1/15/2024	2/14/2024
2	2	1/18/2024	2/17/2024
3	3	2/1/2024	3/2/2024
4	4	2/10/2024	3/11/2024
5	5	3/5/2024	4/4/2024

Example 2: Subtract days from a date

#table(
    type table [OriginalDate = date, OneWeekEarlier = date],
    {{#date(2024, 3, 5), Date.AddDays(#date(2024, 3, 5), -7)}}
)