Fabric Plan Community Logo
Sign in

DATEADD

The DATEADD function adds or subtracts a specified interval from a date value. By default, the function adds the specified number of days when the interval is not provided.

The input dates should be in MM/DD/YYYY format. References are also accepted as arguments.

Syntax

DATEADD(date, count, [interval])

Arguments

  • date: The input date.
  • count: The number of intervals to add or subtract. Positive values add intervals, and negative values subtract intervals.
  • interval (optional): The interval type to apply. Supported values include "day", "month", and "year". If not specified, the function uses "day" by default.

Return value

Returns the calculated date.

Examples

DATEADD([Open Date], 5)

Adds 5 days to the Open Date value.

DATEADD([Open Date], 1, "month")

Adds 1 month to the Open Date value.

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.