mike | Shared With: Everyone - Mar 08 2007 | time, laws, uscode, calendar, excel, DST, 2007
Daylight Saving Time is defined in the US Code. But it has not been updated to reflect the change made in the Energy Policy Act of 2005.
Historical Daylight Saving Time:
First Sunday in April - Last Sunday of OctoberAs amended by The Energy Policy Act of 2005 (begins 2007):
Second Sunday of March - First Sunday of NovemberThe effect of the law is to give us 238 days of DST. Depending on the year, the old rules gave us either 203 or 210 days of DST. The Energy Policy Act adds either 4 or 5 weeks to DST (theoretically saving energy since we'll be up earlier in the day and go to bed earlier at night).
The following Excel formulas calcuate the start and end dates of Daylight Saving Time, following the new rules:
=DATE(Year,3,MOD(1-WEEKDAY(DATE(Year,3,1)),7)+8)
=DATE(Year,11,MOD(1-WEEKDAY(DATE(Year,11,1)),7)+1)The change may NOT be permanent.
Quoted: ENERGY POLICY ACT OF 2005, SEC. 110. DAYLIGHT SAVINGS.
(a) AMENDMENT.—Section 3(a) of the Uniform Time Act of 1966(15 U.S.C. 260a(a)) is amended—
(1) by striking ‘‘first Sunday of April’’ and inserting ‘‘second Sunday of March’’; and
(2) by striking ‘‘last Sunday of October’’ and inserting ‘‘first Sunday of November’’.
(b) EFFECTIVE DATE.—Subsection (a) shall take effect 1 year after the date of enactment of this Act or March 1, 2007, whichever is later.
(c) REPORT TO CONGRESS.—Not later than 9 months after the effective date stated in subsection (b), the Secretary shall report to Congress on the impact of this section on energy consumption in the United States.
(d) RIGHT TO REVERT.—Congress retains the right to revert the Daylight Saving Time back to the 2005 time schedules once the Department study is complete.
Related Content from Around Faves
law
-
Thanks to John (who has not yet subjected himself to the agony) for passing this along during finals. It's a tad dramatic, but pretty great. The before and after shots are the best.
1 FaverViewed: 14 TimesQuoted: A musical look at the rigors of law school.
- baorao - Jul 20 20091 FaverViewed: 11 Times
- baorao - Jul 13 20091 FaverViewed: 5 Times
excel
-
Google Solve feature can solve full-blooded linear programming problems right in your spreadsheet. This is much more sophisticated than the Excel Solve feature which can only change one cell to optimize the output variable.
2 FaversViewed: 6 Times - mike - Apr 23 20094 FaversViewed: 4 Times
- mike - Aug 14 20092 FaversViewed: 2 Times
