Mastering Date Calculations in Power Automate with addDays()

Streamline Your Workflows: Adding Days to Dates in Power Automate

When working with dates in Microsoft Power Automate, one of the most common requirements is adding a specific number of days to an existing date. Whether you're managing approvals, calculating deadlines, sending reminders, or scheduling tasks, date manipulation is an essential part of workflow automation. This guide explains how to use the addDays() function in Power Automate with practical examples.

Why Add Days to a Date?

Adding days to a date is useful in many real-world automation scenarios, including:

• Automatically setting due dates
• Sending follow-up reminders
• Calculating expiry or renewal dates
• Scheduling recurring activities
• Managing SLA-based processes
• Updating records with future dates

Instead of calculating dates manually, Power Automate can perform these calculations dynamically during workflow execution.

The addDays() Function

Power Automate provides a built-in expression called addDays() that allows you to add or subtract days from a specified date.

Syntax

addDays('<startDate>', <numberOfDays>, '<format>')

Parameters

• startDate: The base date from which days will be added or subtracted.
• numberOfDays: The number of days to add (positive) or subtract (negative).
• format: Optional output format for the resulting date.

Example 1: Add 5 Days to the Current Date

To calculate a date that is five days ahead of the current date:

addDays(utcNow(), 5)

If today's date is 2026-06-15, the output will be 2026-06-20.

Example 2: Add Days to a Specific Date

Suppose you have a fixed date:

2026-06-15

Use the following expression:

addDays('2026-06-15', 10)

Result: 2026-06-25

Example 3: Format the Output Date

To return the calculated date in a specific format:

addDays(utcNow(), 7, 'yyyy-MM-dd')

Sample Output: 2026-06-22

Common Date Formats

• yyyy-MM-dd: 2026-06-22
• dd/MM/yyyy: 22/06/2026
• MM-dd-yyyy: 06-22-2026
• yyyy-MM-ddTHH:mm:ssZ: 2026-06-22T10:30:00Z

Example 4: Subtract Days from a Date

You can subtract days by passing a negative value:

Expression: addDays(utcNow(), -3)

Result: Returns a date that is three days before the current date.

Where Can You Use addDays()?

The addDays() function can be used in various Power Automate actions, such as:

• SharePoint List Item Updates
• Dataverse Record Updates
• Approval Workflows
• Outlook Email Reminders
• Microsoft Planner Task Creation
• Scheduled Notifications
• SLA and Escalation Processes

Pro Tip: Combine addDays() with other functions for more advanced scenarios.

Example Combination

formatDateTime(addDays(utcNow(), 2), 'dd-MM-yyyy')

Output: 17-06-2026

Useful Functions to Combine With:

• utcNow(): Returns the current date and time.
• formatDateTime(): Formats date and time values.
• addHours(): Adds hours to a date.
• addMinutes(): Adds minutes to a date.
• addToTime(): Adds custom time intervals.

Best Practices

• Always use UTC dates when working across multiple time zones.
• Apply formatDateTime() when a specific output format is required.
• Validate date values before performing calculations.
• Use negative values in addDays() to calculate past dates.
• Test expressions using the Expression Editor before deploying workflows.

Conclusion

The addDays() function is a simple yet powerful tool for handling date calculations in Microsoft Power Automate. By leveraging this function, you can automate due dates, reminders, task scheduling, and many other business processes without manual intervention.

Understanding how to use addDays() effectively will help you build more dynamic, efficient, and intelligent workflows.