Fabric Plan Community Logo
Sign in

ADDDAYS

The ADDDAYS function adds or subtracts a specified number of days from a date. The input date can be in any supported date format. This function is commonly used to calculate deadlines, due dates, and future or past dates.

Syntax

ADDDAYS(date, value)

Arguments

  • date: The input date. This can also be a measure or reference.
  • value: The number of days to add or subtract. Use a positive value to add days and a negative value to subtract days.

Return value

Returns the calculated date.

Examples

ADDDAYS("05/29/2026", -5)

Returns 05/24/2026.

ADDDAYS("05/29/2026", 10)

Returns 06/08/2026.

Fabric Plan
Enterprise planning, integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co-engineered with Lumel.
CERTIFIED BY
Fabric Planning is certified by IBCS
Microsoft, Azure, Copilot, Excel, Fabric IQ, Microsoft Entra, Microsoft Fabric, Microsoft Teams, OneLake, Outlook, Power Automate, Power BI and SharePoint are trademarks of the Microsoft group of companies. IBCS is a registered trademark of IBCS Association. All other trademarks are the property of their respective owners.

This community is operated independently by Lumel. Nothing on this site constitutes a representation or warranty by Microsoft.