ExcelBanter - Obtain Easter date?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Obtain Easter date? (https://www.excelbanter.com/excel-worksheet-functions/81699-obtain-easter-date.html)

Gabbon

Obtain Easter date?

Hi,
Probably a stupid question,
but does Excel contain any calendar functions that would enable me to create
a formula for obtaining the date of Easter each year?
Thanks.

Ron Coderre

Obtain Easter date?

Check Chip Pearson's site:

http://www.cpearson.com/excel/holidays.htm

Search that webpage for "Easter"

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

"Gabbon" wrote:

Hi,
Probably a stupid question,
but does Excel contain any calendar functions that would enable me to create
a formula for obtaining the date of Easter each year?
Thanks.

Gabbon

Obtain Easter date?

Perfect!
Thanks a bunch

"Ron Coderre" wrote:

Check Chip Pearson's site:

http://www.cpearson.com/excel/holidays.htm

Search that webpage for "Easter"

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

"Gabbon" wrote:

Hi,
Probably a stupid question,
but does Excel contain any calendar functions that would enable me to create
a formula for obtaining the date of Easter each year?
Thanks.

Paul D. Simon

Obtain Easter date?

Here's an even easier formula to determine the date for Easter for a
particular year.

If you enter the year (say, 2006) into cell A1, then in B1 enter this
formula:

=DOLLAR(("4/"&A1)/7+MOD(19*MOD(A1,19)-7,30)*14%,)*7-6

All times are GMT +1. The time now is 09:26 AM.