Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 27th 04, 04:05 PM
Dadgum
 
Posts: n/a
Default Excel template for the date of Easter

Does anyone have access to an Excel template for finding the date of Easter
in any given year in the past or in the future?

  #2   Report Post  
Old December 27th 04, 04:25 PM
Frank Kabel
 
Posts: n/a
Default

Hi
see:
http://tinyurl.com/3lttf

--
Regards
Frank Kabel
Frankfurt, Germany

Dadgum wrote:
Does anyone have access to an Excel template for finding the date of
Easter in any given year in the past or in the future?



  #3   Report Post  
Old December 27th 04, 05:15 PM
Peo Sjoblom
 
Posts: n/a
Default

There was a competition in Germany to find easter date in excel, I believe
this won

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

however it won't work for Mac date system (1904), this formula by Gerhard
Somitsch will

=DATE(A1,3,29.56+0.979*MOD(204-11*MOD(A1,19),30)-
WEEKDAY(DATE(A1,3,28.56+0.979*MOD(204-11*MOD(A1,19),30))))


where you put the year in A1

Regards,

Peo Sjoblom

"Dadgum" wrote:

Does anyone have access to an Excel template for finding the date of Easter
in any given year in the past or in the future?

  #4   Report Post  
Old December 28th 04, 11:04 AM
Barbara Wiseman
 
Posts: n/a
Default

Dadgum,
Chip Pearson has a good section on dates & times including Easter
http://www.cpearson.com/excel/holidays.htm#Easter

Barbara


Dadgum wrote:
Does anyone have access to an Excel template for finding the date of
Easter in any given year in the past or in the future?





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto date changing in Excel is maddening brhicks Charts and Charting in Excel 3 December 16th 04 02:54 PM
USING THE DATE FORMAT IN EXCEL teach Excel Discussion (Misc queries) 3 December 14th 04 11:55 PM
Excel 2003 "File Open": how keep folders at top with sort by Date. Aging Analyst Excel Discussion (Misc queries) 1 December 3rd 04 03:26 AM
Does the add in Template Wizard exist for Excel 2003 Casey Excel Discussion (Misc queries) 2 December 2nd 04 05:55 PM
Creating a Date Selector in Excel VBA? Mark Excel Discussion (Misc queries) 0 November 25th 04 10:59 PM


All times are GMT +1. The time now is 10:23 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017