Date and Time Calculations in Power Automate: Complete Guide
Stop wasting time wrestling with date calculations in Power Automate! This hands-on tutorial shows you exactly how to master date and time expressions—unlocking powerful workflow automation for business process automation, digital transformation, and citizen development in the Microsoft Power Platform.
You'll learn real-world techniques to easily calculate the first or last day of a month, find the nth working day, retrieve all Fridays (or any weekday) in a month, and even handle tricky time zone or ISO 8601 formatting errors. Whether you're building Power Apps, automating approvals, or scheduling reminders, these low-code tips will save you hours and help you avoid common pitfalls.
What You’ll Learn:
✔️ Format dates and times for any locale or business scenario in Power Automate
✔️ Automate calculations for first/last/nth day of month, next weekday, and working days
✔️ Handle time zone conversions and fix ISO 8601 errors with new expressions
✔️ Build dynamic arrays of dates for advanced workflow automation and reporting
Timestamps:
00:00 – How to Automate Complex Date Calculations in Power Automate
00:37 – Fixing ISO 8601 Date Format Errors Easily
03:23 – Formatting Current Date and Time for Your Locale
05:30 – Converting UTC to Any Time Zone (e.g., Hawaiian)
07:11 – Calculating the First Day of Any Month
08:10 – Finding the Nth Day of the Month
08:58 – Getting the Last Day of the Month Automatically
10:17 – Setting Specific Times on Any Date
11:38 – Finding the Next Occurrence of Any Weekday
19:00 – Creating Arrays of All Days in a Month
23:50 – Retrieving All Fridays and the 1st/3rd Friday of a Month
26:50 – Excluding Weekends to Get the 10th Working Day
29:00 – Wrap-Up and Next Steps
#PowerAutomate #workflowautomation #PowerPlatform #LowCode #digitaltransformation
Want more Power Apps and Power Automate tips? Download the sample flow (link in description) and drop your date/time challenges or questions in the comments—I’m here to help you automate smarter!
Additional Links:
🔗 • Automate Working Day Calculation in Power ... Power Automate tutorial on calculating working days, excluding holidays.
📝 https://www.damobird365.com/formatdat... Further examples and explanations on date and time formatting in Power Automate.
💾 https://github.com/DamoBird365/PowerA... Downloadable Power Automate flow for date/time manipulation.
📖 https://docs.microsoft.com/en-us/azur... Microsoft documentation on date and time functions in Power Automate.
🗺️ https://docs.microsoft.com/en-us/wind... Microsoft documentation on time zones.
🗣️ https://powerusers.microsoft.com/t5/P... Community post with expressions for calculating the next day of the week.
🫠 About me:
👋 Hi, I'm Damien Bird — Power Platform Cloud Solution Architect at Microsoft ☁️
🧠 Former Forum Super User (2021/22) & Business Applications MVP (2022)
🎤 Speaker at conferences across Europe, the US, and local UK user groups
💡 Passionate about sharing knowledge, solving problems, and empowering the community with the Power Platform!
📚 Explore more:
🔗 Blog: https://DamoBird365.com
🎥 Video & Quiz CPD: https://DamoBird365.com/YouTube
💖 Support the Channel: / @damobird365
☕ Buy Me a Coffee: https://BuyMeACoffee.com/DamoBird365
💼 LinkedIn: / damobird365
🐦 Twitter: https://x.com/DamoBird365
🌐 Bluesky: https://bsky.app/profile/DamoBird365....
📜 Feedback or Request: https://forms.office.com/e/WAV1iF2Wis