Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Dec 2008
    Location
    Sydney, New South Wales, Australia
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date Calculations in Word (2008 1222 0855)

    Hi there,

    I am trying to Find The Day Of The Week Of A Gregorian Calendar Date as a one digit number rather than as the name of the day where 1 = Mon., 2 = Tue., etc.

    Michael

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

    Re: Date Calculations in Word (2008 1222 0855)

    Welcome to Woody's Lounge!

    You'll find more than you ever wanted to know in macropod's star post <!post=Date Calculations in Word,249902>Date Calculations in Word<!/post>.

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

    Re: Date Calculations in Word (2008 1222 0855)

    Hi Michael,

    Using the code from my Date Calc tutorial for the field under the heading "Convert a Gregorian Calendar Date to a Julian Day Number", change the code in the last line from:
    '{jd # ,0}'
    to:
    '{=MOD(jd,7)+1 # 0}'
    This will return Mon = 1 through Sun = 7.
    .
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  4. #4
    New Lounger
    Join Date
    Dec 2008
    Location
    Sydney, New South Wales, Australia
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Calculations in Word (2008 1222 0855)

    Paul,

    It works perfectly. Thank you very much.

    Regards,
    Michael

  5. #5
    New Lounger
    Join Date
    Dec 2008
    Location
    Sydney, New South Wales, Australia
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Calculations in Word (2008 1222 0855)

    Hans,

    Thank you very much.

    Regards,
    Michael

Posting Permissions

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