Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default Which historical year will offer the same weekday ... ?

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default Which historical year will offer the same weekday ... ?

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,574
Default Which historical year will offer the same weekday ... ?

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 623
Default Which historical year will offer the same weekday ... ?

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 31
Default Which historical year will offer the same weekday ... ?


"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   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



Reply
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 01:18 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"