Easter dating table

17-Jun-2017 19:16

I have adapted their BASIC formula for use as an Excel UDF also.

The code is provided later, after the code for the UDF based on the USNO published algorithm.

I ran tests to obtain an average time to return a single result for all the algorithms presented.

The test results should be considered as relative to one another, not absolutes.

Leave to cool in the tin for 10 minutes before turning out onto a wire rack.

When the cake is cooled, warm the apricot jam gently with a splash of water in a small pan over a low heat, sieve, then brush over the top of the cake.

Bake for about two hours until the cake is well risen and firm to the touch.

Prasad DV =TRUNC(DATE(J,7,-CODE(MID("NYDQ\JT_LWBOZER]KU`", MOD(J,19) 1,1)))/7)*7 8 Note: in the above formulas J is a named cell containing the year to evaluate.

The Norbert Hetterich formula is presented on Chip Pearson's site with a minor modification to format the result in typical U. date format as: =FLOOR("5/"&DAY(MINUTE(A59/38)/2 56)&"/"&A59,7)-34 Another interesting formula is attributed to Gerhardt Somitsch (presented where cell A2 contains a year value): =DATE(A2,3,29.56 0.979*MOD(204-11*MOD(A2,19),30) - WEEKDAY(DATE(A2,3,28.56 0.979*MOD(204-11*MOD(A2,19),30)))) The good thing about these various formulas is that they do work for the near future (at least through 2078), and that's all most of us need at this point in time.

I've also contacted the ASSU and provided them with the code for the UDF to use at their discretion. However, as you'll see shortly, the version presented by Daniel.

Additional algorithms have been attributed to Claus Tondering (page 26 and page 27) and Laurent Longre, who also publishes the More add-in for Excel. M in the groups.link above is a significant piece of code.

Bake for about two hours until the cake is well risen and firm to the touch.Prasad DV =TRUNC(DATE(J,7,-CODE(MID("NYDQ\JT_LWBOZER]KU`", MOD(J,19) 1,1)))/7)*7 8 Note: in the above formulas J is a named cell containing the year to evaluate.The Norbert Hetterich formula is presented on Chip Pearson's site with a minor modification to format the result in typical U. date format as: =FLOOR("5/"&DAY(MINUTE(A59/38)/2 56)&"/"&A59,7)-34 Another interesting formula is attributed to Gerhardt Somitsch (presented where cell A2 contains a year value): =DATE(A2,3,29.56 0.979*MOD(204-11*MOD(A2,19),30) - WEEKDAY(DATE(A2,3,28.56 0.979*MOD(204-11*MOD(A2,19),30)))) The good thing about these various formulas is that they do work for the near future (at least through 2078), and that's all most of us need at this point in time.I've also contacted the ASSU and provided them with the code for the UDF to use at their discretion. However, as you'll see shortly, the version presented by Daniel.Additional algorithms have been attributed to Claus Tondering (page 26 and page 27) and Laurent Longre, who also publishes the More add-in for Excel. M in the groups.link above is a significant piece of code.Call 08 or visit books.uk Read more: Paul Hollywood: bring back the Caramac Easter egg There are over 87,000 different drink combinations at Starbucks, according to the coffee retailer’s website. From flu remedies to Harry Potter-inspired beverages, we highlight the weird and the wonderful brews and infusions.