Posted to microsoft.public.excel.worksheet.functions

David2me

external usenet poster

Posts: 1

Easter day formula.

Thanks for the formula. Just a note for those looking to use the formula. The cell reference is for the year. A cut-n-paste formula for google sheets is :

=FLOOR("5/"&DAY(MINUTE(year(today())/38)/2+56)&"/"&year(today()),7)-34

It replaces the cell reference with the formula for the current year. An auto updating Easter formula.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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
Easter day formula.	[email protected]	Excel Worksheet Functions	0	April 14th 13 12:55 PM
easter egg in excel 2003	chanchai	Excel Discussion (Misc queries)	0	December 21st 09 11:29 AM
Easter day formula	Antonio Atala	Excel Programming	9	January 23rd 07 07:42 AM
Obtain Easter date?	Gabbon	Excel Worksheet Functions	3	April 6th 06 02:04 PM
Easter Eggs?	Rodney	New Users to Excel	1	May 10th 05 11:45 AM

All times are GMT +1. The time now is 03:46 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us