Results 1 to 11 of 11

Thread: Day of Week

  1. #1
    Silver Lounger
    Join Date
    Aug 2001
    Location
    Canton, Ohio, USA
    Posts
    1,716
    Thanks
    0
    Thanked 1 Time in 1 Post

    Day of Week

    Anyone know of a freeware program that will tell me what day of the week a certain date was that is back in the 1950s?

    I used the
    H Lewton

  2. #2
    Super Moderator
    Join Date
    Dec 2000
    Location
    Renton, Washington, USA
    Posts
    12,560
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Re: Day of Week

    Google search gave me "Searched the web for "Day of Week ". Results 1 - 10 of about 262,000. Search took 0.59 seconds. "

    Now running HP Pavilion a6528p, with Win7 64 Bit OS.

  3. #3
    Silver Lounger
    Join Date
    Aug 2001
    Location
    Canton, Ohio, USA
    Posts
    1,716
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Day of Week

    Dave,

    Yeah, I did the same thing before posting. I didn't find it that useful, that is why I posted. Sorry if it bothered you but I thought that was the purpose of the Lounge - to help others. It probably took you longer to post your reply than it took to Google.
    H Lewton

  4. #4
    Silver Lounger
    Join Date
    Aug 2001
    Location
    Canton, Ohio, USA
    Posts
    1,716
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Day of Week

    HansV,

    Thanks for the information. I guess the day was correct that Excel calculated.
    H Lewton

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Day of Week

    If you use the standard date system in Excel, weekdays will be accurate from March 1, 1900 until far in the future. Because of an error in Lotus 1-2-3 that was copied in Excel for compatibility reasons (grrrr...), dates before that are one day off. According to the Gregorian calendar, 1900 was not a leap year, so there was no February 29, 1900. But the Lotus programmers hadn't taken that into account, and so more than 15 years on (after Lotus 1-2-3 had its heydey), Excel still acts as if February 29, 1900 exists.

  6. #6
    Super Moderator
    Join Date
    Dec 2000
    Location
    Renton, Washington, USA
    Posts
    12,560
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Re: Day of Week

    There are MANY sites listed using Google, just wanted to give you a choice. A lot are sites that list "script files" to be used. The following will do what you need but on line.

    http://www.travelfurther.net/dates/datesrus.asp on line use (first one listed in the advance search)
    http://www.searchforancestors.com/ut...dayofweek.html on line use
    http://www.geocities.com/Heartland/P...714/zeller.htm on line use

    Now running HP Pavilion a6528p, with Win7 64 Bit OS.

  7. #7
    Silver Lounger
    Join Date
    Aug 2001
    Location
    Canton, Ohio, USA
    Posts
    1,716
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Day of Week

    Dave,

    Thanks for the help.
    H Lewton

  8. #8
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    Tokyo, Japan
    Posts
    203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Day of Week

    Try inserting a Calendar Control in Word. It goes back from 1900 to 2100.

  9. #9
    Silver Lounger
    Join Date
    Aug 2001
    Location
    Canton, Ohio, USA
    Posts
    1,716
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Day of Week

    Jolas,

    Thanks, I'll look into it.
    H Lewton

  10. #10
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Day of Week

    You can do it in Word using fields too:

    {QUOTE
    {ASK AskDate "What is date do you want the weekday for, in dd/mm/yyyy format, please?" d {DATE @ "d/MM/yyyy"}}
    {SET d{AskDate @ d}}
    {SET m{AskDate @ MM}}
    {SET y{AskDate @ yyyy}}
    {SET jd{=INT(365.25*(y+4799+INT((m+10)/12)))+INT(367/12*MOD(m+10,12))-INT(3*INT((y+4901+INT((m+10)/12))/100)/4)+d-32075}}
    {AskDate @ "d
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  11. #11
    Silver Lounger
    Join Date
    Aug 2001
    Location
    Canton, Ohio, USA
    Posts
    1,716
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Day of Week

    macropod,

    Thanks for the info and the code.
    H Lewton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •