Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
2001 is the most recent. Easy to calculate, 6 years + 1 leap year = 7 days.
-- David Biddulph "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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I think you mean 7 years, but 2001 is six years ago, not seven?
-- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "David Biddulph" wrote: 2001 is the most recent. Easy to calculate, 6 years + 1 leap year = 7 days. -- David Biddulph "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 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
365 days per year divided by 7 days per week yields a year of 52 weeks and one
day. Therefore, in a normal year a day falling on a Friday this year will fall on Thursday next year. Except in leap years, where there will be two days difference. So the same weekday will always be five or six years ago depending on how many leap days there are in between. Google 'perpetual calendar' and you'll quickly be able to see which years in the century have the same days of the week configuration. -- Regards, Fred "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 |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() "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 Hi Eric. An easy general way to get the same weekday, and weeknumbers american and ISO, is to add 400 years to the date. 400 years is 20871 weeks, counting the various leap days, and then the calendar repeats itself, if you don't consider easter. So 16 Mar 1607 was also a Friday, if your calendar was gregorian then. Excel has a discrepancy 1/1/1900 and 60 days forward, 1/1/1900 weekday isn't 1/1/2300 weekday in Excel, but it should be. The 1/1/2300 ... weekdays are the correct ones. Hope that was useful, Hans. |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Opening Excel - online help offer | Excel Discussion (Misc queries) | |||
WEEKDAY() function: display TEXT not numeric weekday | Excel Discussion (Misc queries) | |||
WEEKDAY question on year | Excel Discussion (Misc queries) | |||
Can anyone offer a solution ? | New Users to Excel | |||
How do I offer ChartType options? | Charts and Charting in Excel |