Fabric Plan Community Logo
Sign in

DAY

The DAY function extracts the day value from a date. This function is commonly used to analyze and group data based on the day of the month.

Note

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

Syntax

DAY(date)

Arguments

  • date: The input date.

Return value

Returns the day value from the specified date.

Example

DAY(Open Date)

Extracts the day value from the Open Date field. For example, if Open Date is 05/22/2026, the function returns 22.

Excel equivalent

DAY

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.