Skip to content

Plan Your Next EXCELlent Easter!

October 29, 2009

Ok, Excel geeks. It’s easy to specify Christmas, New Year’s, and other such holidays in an Excel report. It’s even easy to specify Third Thursday Of The Month or First Sunday After The 17th or whatever. But, how do you find Next Easter?

Well, it’s incredibly complicated. You can Google it and enter the date you need, but don’t you really want to just automate using formulas? Of course you do! So, here ya’ go:

=IF(TODAY()>FLOOR(“5/”&DAY(MINUTE((YEAR(TODAY())+0)/38)/2+56)&”/”&(YEAR(TODAY())+0),7)-34,FLOOR(“5/”&DAY(MINUTE((YEAR(TODAY())+1)/38)/2+56)&”/”&(YEAR(TODAY())+1),7)-34,FLOOR(“5/”&DAY(MINUTE((YEAR(TODAY())+0)/38)/2+56)&”/”&(YEAR(TODAY())+0),7)-34)

It’s just that easy. And if you want Easter dates for other years, just enter another year in the TODAY() spot or reference a cell value rather than TODAY() and you can plug in dates quickly and easily.

Have fun!

Advertisements
No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: