Home |
Search |
Today's Posts |
#4
![]()
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 |
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 |