Basically Yogi's formula is calculating on a base Week day
default of 1 - 7 = Sunday - Saturday using american Dates
(to change to English others =(1&"/"&G2)+0-WEEKDAY(1&"/"&G2)+29)
4th sunday = 4 X 7 + Base Day = 1 +> +29
(B4&"/"&1)+0 coerces the date serial number for the 1st of the Month of the current year (US)
Adding them together yeilds 4th Sunday as a Serial number.
Note: Only applicable for North America as daylight savings is different for different continents eg.
<META content=Excel.Sheet name=ProgId><META content="Microsoft Excel 9" name=Generator><LINK href="./sht_files/filelist.xml" rel=File-List><STYLE>v\:* {behavior:url(#default#VML);}o\:* {behavior:url(#default#VML);}x\:* {behavior:url(#default#VML);}.shape {behavior:url(#default#VML);}</STYLE><STYLE id="daylight savings times_909_Styles"></STYLE> <DIV id="daylight savings times_909" align=center x
ublishsource="Excel"><TABLE style="TABLE-LAYOUT: fixed; WIDTH: 655pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=872 border=0 x:str><COLGROUP><COL style="WIDTH: 212pt; mso-width-source: userset; mso-width-alt: 10313" width=282><COL style="WIDTH: 180pt; mso-width-source: userset; mso-width-alt: 8777" width=240><COL style="WIDTH: 263pt; mso-width-source: userset; mso-width-alt: 12800" width=350><TBODY><TR style="HEIGHT: 27pt; mso-height-source: userset" height=36><TD class=xl26909 style="WIDTH: 212pt; HEIGHT: 27pt" width=282 height=36>Continent</TD><TD class=xl26909 style="BORDER-LEFT: medium none; WIDTH: 180pt" width=240>Country</TD><TD class=xl26909 style="BORDER-LEFT: medium none; WIDTH: 263pt" width=350>Beginning and ending days</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl23909 style="BORDER-TOP: medium none; WIDTH: 212pt; HEIGHT: 25.5pt" width=282 height=34 rowSpan=2>Africa</TD><TD class=xl24909 style="BORDER-TOP: medium none; WIDTH: 180pt" width=240 rowSpan=2>Egypt</TD><TD class=xl23909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt" width=350>Start: <FONT class=font5909>Last Friday in April</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl23909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt; HEIGHT: 12.75pt" width=350 height=17>End: <FONT class=font5909>Last Thursday in September</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl27909 style="BORDER-TOP: medium none; WIDTH: 212pt; HEIGHT: 25.5pt" width=282 height=34 rowSpan=2> </TD><TD class=xl25909 style="BORDER-TOP: medium none; WIDTH: 180pt" width=240 rowSpan=2>Namibia</TD><TD class=xl22909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt" width=350>Start: <FONT class=font5909>First Sunday in September</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt; HEIGHT: 12.75pt" width=350 height=17>End: <FONT class=font5909>First Sunday in April</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl23909 style="BORDER-TOP: medium none; WIDTH: 212pt; HEIGHT: 25.5pt" width=282 height=34 rowSpan=2>Asia</TD><TD class=xl24909 style="BORDER-TOP: medium none; WIDTH: 180pt" width=240 rowSpan=2>Most states of the former USSR</TD><TD class=xl23909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt" width=350>Start: <FONT class=font5909>Last Sunday in March</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl23909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt; HEIGHT: 12.75pt" width=350 height=17>End: <FONT class=font5909>Last Sunday in October</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl27909 style="BORDER-TOP: medium none; WIDTH: 212pt; HEIGHT: 25.5pt" width=282 height=34 rowSpan=2> </TD><TD class=xl25909 style="BORDER-TOP: medium none; WIDTH: 180pt" width=240 rowSpan=2>Iraq</TD><TD class=xl22909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt" width=350>Start: <FONT class=font5909>April 1</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt; HEIGHT: 12.75pt" width=350 height=17>End: <FONT class=font5909>October 1</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24909 style="BORDER-TOP: medium none; WIDTH: 212pt; HEIGHT: 38.25pt" width=282 height=51 rowSpan=3> </TD><TD class=xl24909 style="BORDER-TOP: medium none; WIDTH: 180pt" width=240 rowSpan=3>Israel</TD><TD class=xl24909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt" width=350>(Estimate, Israel decides the dates every year)</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl23909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt; HEIGHT: 12.75pt" width=350 height=17>Start: <FONT class=font5909>First Friday in April</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl23909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt; HEIGHT: 12.75pt" width=350 height=17>End: <FONT class=font5909>First Friday in September</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl27909 style="BORDER-TOP: medium none; WIDTH: 212pt; HEIGHT: 25.5pt" width=282 height=34 rowSpan=2> </TD><TD class=xl25909 style="BORDER-TOP: medium none; WIDTH: 180pt" width=240 rowSpan=2>Lebanon, Kirgizstan</TD><TD class=xl22909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt" width=350>Start: <FONT class=font5909>Last Sunday in March</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt; HEIGHT: 12.75pt" width=350 height=17>End:<FONT class=font5909> Last Sunday in October</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24909 style="BORDER-TOP: medium none; WIDTH: 212pt; HEIGHT: 25.5pt" width=282 height=34 rowSpan=2> </TD><TD class=xl24909 style="BORDER-TOP: medium none; WIDTH: 180pt" width=240 rowSpan=2>Mongolia</TD><TD class=xl23909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt" width=350>Start: <FONT class=font5909>Last Sunday in March</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl23909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt; HEIGHT: 12.75pt" width=350 height=17>End: <FONT class=font5909>Last Sunday in September</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl25909 style="BORDER-TOP: medium none; WIDTH: 212pt; HEIGHT: 38.25pt" width=282 height=51 rowSpan=3> </TD><TD class=xl25909 style="BORDER-TOP: medium none; WIDTH: 180pt" width=240 rowSpan=3>Palestine</TD><TD class=xl25909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt" width=350>(Estimate)</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt; HEIGHT: 12.75pt" width=350 height=17>Start: <FONT class=font5909>First Friday on or after 5 April</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt; HEIGHT: 12.75pt" width=350 height=17>End: <FONT class=font5909>First Friday on or after 5 October</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24909 style="BORDER-TOP: medium none; WIDTH: 212pt; HEIGHT: 25.5pt" width=282 height=34 rowSpan=2> </TD><TD class=xl24909 style="BORDER-TOP: medium none; WIDTH: 180pt" width=240 rowSpan=2>Syria</TD><TD class=xl23909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt" width=350>Start: <FONT class=font5909>April 1</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl23909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt; HEIGHT: 12.75pt" width=350 height=17>End: <FONT class=font5909>October 1</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl27909 style="BORDER-TOP: medium none; WIDTH: 212pt; HEIGHT: 25.5pt" width=282 height=34 rowSpan=2> </TD><TD class=xl25909 style="BORDER-TOP: medium none; WIDTH: 180pt" width=240 rowSpan=2>Iran</TD><TD class=xl22909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt" width=350>Start:<FONT class=font5909> the first day of Farvardin</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt; HEIGHT: 12.75pt" width=350 height=17>End:<FONT class=font5909> the first day of Mehr </FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl23909 style="BORDER-TOP: medium none; WIDTH: 212pt; HEIGHT: 12.75pt" width=282 height=17>Australasia</TD><TD class=xl24909 style="BORDER-TOP: medium none; WIDTH: 180pt" width=240 rowSpan=2>Australia - South Australia, Victoria, Australian Capital Territory, New South Wales, Lord Howe Island</TD><TD class=xl23909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt" width=350>Start: <FONT class=font5909>Last Sunday in October</FONT></TD></TR><TR style="HEIGHT: 38.25pt" height=51><TD class=xl24909 style="BORDER-TOP: medium none; WIDTH: 212pt; HEIGHT: 38.25pt" width=282 height=51>(region that encompasses Australia, Tasmania, New Zealand, and other islands in the South Pacific)</TD><TD class=xl23909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt" width=350>End: <FONT class=font5909>Last Sunday in March</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl27909 style="BORDER-TOP: medium none; WIDTH: 212pt; HEIGHT: 25.5pt" width=282 height=34 rowSpan=2> </TD><TD class=xl25909 style="BORDER-TOP: medium none; WIDTH: 180pt" width=240 rowSpan=2>Australia - Tasmania</TD><TD class=xl22909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt" width=350>Start: <FONT class=font5909>First Sunday in October</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt; HEIGHT: 12.75pt" width=350 height=17>End: <FONT class=font5909>Last Sunday in March</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24909 style="BORDER-TOP: medium none; WIDTH: 212pt; HEIGHT: 25.5pt" width=282 height=34 rowSpan=2> </TD><TD class=xl24909 style="BORDER-TOP: medium none; WIDTH: 180pt" width=240 rowSpan=2>Fiji</TD><TD class=xl23909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt" width=350>Start: <FONT class=font5909>First Sunday in November</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl23909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt; HEIGHT: 12.75pt" width=350 height=17>End: <FONT class=font5909>Last Sunday in February</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl25909 style="BORDER-TOP: medium none; WIDTH: 212pt; HEIGHT: 25.5pt" width=282 height=34 rowSpan=2> </TD><TD class=xl25909 style="BORDER-TOP: medium none; WIDTH: 180pt" width=240 rowSpan=2>New Zealand, Chatham</TD><TD class=xl22909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt" width=350>Start: <FONT class=font5909>First Sunday in October</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt; HEIGHT: 12.75pt" width=350 height=17>End: <FONT class=font5909>First Sunday on or after 5 March</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24909 style="BORDER-TOP: medium none; WIDTH: 212pt; HEIGHT: 25.5pt" width=282 height=34 rowSpan=2> </TD><TD class=xl24909 style="BORDER-TOP: medium none; WIDTH: 180pt" width=240 rowSpan=2>Tonga</TD><TD class=xl23909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt" width=350>Start: <FONT class=font5909>First Saturday in October</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl23909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt; HEIGHT: 12.75pt" width=350 height=17>End: <FONT class=font5909>First Saturday on or after 15 April</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22909 style="BORDER-TOP: medium none; WIDTH: 212pt; HEIGHT: 25.5pt" width=282 height=34 rowSpan=2>Europe</TD><TD class=xl25909 style="BORDER-TOP: medium none; WIDTH: 180pt" width=240 rowSpan=2>European Union, Russia</TD><TD class=xl22909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt" width=350>Start: <FONT class=font5909>Last Sunday in March</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt; HEIGHT: 12.75pt" width=350 height=17>End: <FONT class=font5909>Last Sunday in October</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24909 style="BORDER-TOP: medium none; WIDTH: 212pt; HEIGHT: 25.5pt" width=282 height=34 rowSpan=2> </TD><TD class=xl24909 style="BORDER-TOP: medium none; WIDTH: 180pt" width=240 rowSpan=2>Greenland</TD><TD class=xl23909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt" width=350>Start: <FONT class=font5909>First Sunday in April</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl23909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt; HEIGHT: 12.75pt" width=350 height=17>End: <FONT class=font5909>Last Sunday in October</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22909 style="BORDER-TOP: medium none; WIDTH: 212pt; HEIGHT: 25.5pt" width=282 height=34 rowSpan=2>North America</TD><TD class=xl25909 style="BORDER-TOP: medium none; WIDTH: 180pt" width=240 rowSpan=2>Canada, United States, Mexico, St. Johns, Bahamas, Turks and Caicos</TD><TD class=xl22909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt" width=350>Start: <FONT class=font5909>First Sunday in April</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt; HEIGHT: 12.75pt" width=350 height=17>End: <FONT class=font5909>Last Sunday in October</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24909 style="BORDER-TOP: medium none; WIDTH: 212pt; HEIGHT: 25.5pt" width=282 height=34 rowSpan=2> </TD><TD class=xl24909 style="BORDER-TOP: medium none; WIDTH: 180pt" width=240 rowSpan=2>Cuba</TD><TD class=xl23909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt" width=350>Start: <FONT class=font5909>April 1</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl23909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt; HEIGHT: 12.75pt" width=350 height=17>End: <FONT class=font5909>Last Sunday in October</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22909 style="BORDER-TOP: medium none; WIDTH: 212pt; HEIGHT: 25.5pt" width=282 height=34 rowSpan=2>South America</TD><TD class=xl25909 style="BORDER-TOP: medium none; WIDTH: 180pt" width=240 rowSpan=2>Brazil</TD><TD class=xl22909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt" width=350>Start: <FONT class=font5909>First Sunday in October</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt; HEIGHT: 12.75pt" width=350 height=17>End: <FONT class=font5909>Last Sunday in February</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24909 style="BORDER-TOP: medium none; WIDTH: 212pt; HEIGHT: 25.5pt" width=282 height=34 rowSpan=2> </TD><TD class=xl24909 style="BORDER-TOP: medium none; WIDTH: 180pt" width=240 rowSpan=2>Chile</TD><TD class=xl23909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt" width=350>Start: <FONT class=font5909>First Sunday on or after 9 October</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl23909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt; HEIGHT: 12.75pt" width=350 height=17>End: <FONT class=font5909>First Sunday on or after 9 March</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl25909 style="BORDER-TOP: medium none; WIDTH: 212pt; HEIGHT: 25.5pt" width=282 height=34 rowSpan=2> </TD><TD class=xl25909 style="BORDER-TOP: medium none; WIDTH: 180pt" width=240 rowSpan=2>Falklands</TD><TD class=xl22909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt" width=350>Start: <FONT class=font5909>First Sunday on or after 8 September</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt; HEIGHT: 12.75pt" width=350 height=17>End: <FONT class=font5909>First Sunday on or after 6 April</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24909 style="BORDER-TOP: medium none; WIDTH: 212pt; HEIGHT: 25.5pt" width=282 height=34 rowSpan=2> </TD><TD class=xl24909 style="BORDER-TOP: medium none; WIDTH: 180pt" width=240 rowSpan=2>Paraguay</TD><TD class=xl23909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt" width=350>Start: <FONT class=font5909>First Sunday in October</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl23909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt; HEIGHT: 12.75pt" width=350 height=17>End: <FONT class=font5909>Last Saturday in February</FONT></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22909 style="BORDER-TOP: medium none; WIDTH: 212pt; HEIGHT: 12.75pt" width=282 height=17>Antarctica</TD><TD class=xl25909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 180pt" width=240>Antarctica</TD><TD class=xl25909 style="BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 263pt" width=350>(same as Chile)</TD></TR></TBODY></TABLE></DIV>