Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 11th 20, 08:56 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2020
Posts: 1
Default 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
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
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 12:29 PM
Easter day formula Antonio Atala Excel Programming 9 January 23rd 07 08: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 06:12 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