LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default Which historical year will offer the same weekday ... ?

No I meant 7 days, Dave. In a normal year a date will move by one day of
the week from year to year. In a leap year it moves by two days of the
week. 2001 is indeed six years ago, so the date moves by one day for each
of those 6 years, plus an extra day for the one leap year in that period,
hence the date moves by 7 days, so in other words it's back to the same day
of the week.

Q.E.D.
--
David Biddulph

"Dave F" wrote in message
...
I think you mean 7 years, but 2001 is six years ago, not seven?


"David Biddulph" wrote:

2001 is the most recent. Easy to calculate, 6 years + 1 leap year = 7
days.


"Eric" wrote in message
...
Today is 16 Mar, 2007 (Friday), does anyone know which historical year
will
offer 16 Mar on Friday? On the other words, which historical year will
offer
the same weekday on 2007 for everyday?
Thank for any suggestions
Eric



 
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
Opening Excel - online help offer JWF Excel Discussion (Misc queries) 3 January 28th 09 04:30 PM
WEEKDAY() function: display TEXT not numeric weekday tom Excel Discussion (Misc queries) 3 November 21st 06 04:32 PM
WEEKDAY question on year mrjeep Excel Discussion (Misc queries) 2 May 3rd 06 09:02 AM
Can anyone offer a solution ? pc300d New Users to Excel 11 April 17th 06 09:56 PM
How do I offer ChartType options? davidm Charts and Charting in Excel 4 December 29th 05 02:13 PM


All times are GMT +1. The time now is 09:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"