web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate - Building Flows Calculate last day of ...

Power Automate - Building Flows

Answered

Calculate last day of month (EOM)

(0) Share

Report

Report

Posted on by MelissaReed

288

For accounting purposes, I need to calculate the last day of the month a bill is due.
There is (currently) no "Last Day of the Month" or "End of Month function in P/Au" --- so how do I calculate EOM() date?

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

MelissaReed

288 on at

Like (0)

Report

Report

Re: Calculate last day of month (EOM)

Short answer:

addDays(startOfMonth(addDays(startOfMonth('2022-08-03'),31)),-1)

There is now a startOfMonth() function that greatly simplifies this from older solutions to this question I see out there.

To break this down from the inside out:

Choose a date – UTCNow(), or item()?[‘Due Date’] -- 2/15/2022
Get that date’s Start of Month -- 2/1/2022
Add 31 days to that – the most days in any month – to put the date into the next month -- 3/4/2022
Get that date’s Start of Month – 3/1/2022
Subtract one from that date which puts you on the last day of the prior month (your month) – 2/28/2022.

This approach lets Microsoft worry about “30 days hath September…” and leap years

I put a series of Due Dates into an array, did a Select using this formula to calculate Last Day Of Month for the Due Date:

Results:

Due Date	Last Day of Month
2022-01-01	2022-01-31
2022-01-02	2022-01-31
2022-01-29	2022-01-31
2022-01-30	2022-01-31
2022-01-31	2022-01-31
2022-02-01	2022-02-28
2022-02-02	2022-02-28
2022-02-28	2022-02-28
2022-03-01	2022-03-31
2022-03-02	2022-03-31
2022-03-03	2022-03-31
2022-03-29	2022-03-31
2022-03-30	2022-03-31
2022-03-31	2022-03-31

I hope this is helpful – it was nice to have a chance to give back after this board has saved me so many times!

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 659 Super User 2025 Season 2

#2

Tomac 386 Moderator

#3

chiaraalina 290

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans