2
Hello,
I'm working on creation of holiday reservation system via Lists and power automate. I've sucessfully excluded weekend days and now I'm trying to exclude public holidays. Is it possible to calculate Easter Sunday date for the next year?
Thanks for any idea!
Petr
I know this is an older post, but in case anyone is doing a search on how to calculate Easter Sunday, here is how you do it. You'll need a few Composes...
I have a Compose called Year that holds the year that I'm trying to find the date.
a
Share
Report
All responses (
Answers (
mod(outputs('Year'), 19)
b
div(outputs('Year'), 100)
c
mod(outputs('Year'), 100)
d
div(outputs('b'), 4)
e
mod(outputs('b'), 4)
g
div(add(mul(8, outputs('b')), 13), 25)
h
mod(add(sub(sub(add(mul(19, outputs('a')), outputs('b')), outputs('d')), outputs('g')), 15), 30)
i
div(outputs('c'), 4)
k
mod(outputs('c'), 4)
l
mod(sub(sub(add(add(32, mul(2, outputs('e'))), mul(2, outputs('i'))), outputs('h')), outputs('k')), 7)
m
div(add(add(outputs('a'), mul(11,outputs('h'))), mul(19, outputs('l'))), 433)
n
div(add(sub(add(outputs('h'), outputs('l')), mul(7, outputs('m'))), 90), 25)
p
mod(add(add(sub(add(outputs('h'), outputs('l')), mul(7, outputs('m'))), mul(33, outputs('n'))), 19), 32)
Month = n
Day = p
My Easter Days are string variables:
varEasterSunday
outputs('n')/outputs('p')/outputs('Year')
varEasterMonday
addDays(variables('varEasterSunday'), 1)
varGoodFriday
addDays(variables('varEasterSunday'), -2)
I hope that this helps someone out there.
Source for equation: https://en.wikipedia.org/wiki/Date_of_Easter#Algorithms
Easter is determined as first Sunday after first full moon after Spring equinox, so you'd need moon data to calculate it. It might be easier to just make an array of Easter dates for the next 10 years or so and use that.
Pat
#1
Michael E. Gernaey
566
Super User 2025 Season 1
#2
David_MA
516
Super User 2025 Season 1
#3
stampcoin
492
