Results 1 to 4 of 4

Thread: Day of Year

  1. #1
    3 Star Lounger baumgrenze's Avatar
    Join Date
    Feb 2001
    Location
    California, USA
    Posts
    262
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Day of Year

    I poked through the help for Excel 97 SR-1 in search of a "Day of Year" function. I wanted a row in which the date in the row above was expressed as which of the 365 days of the year it represented. I could not find it. Perhaps I just failed to search for the proper index term. Does it exist?

    Thanks,

    Baumgrenze
    Baumgrenze
    Hier sind wir tief eingewurzelt.

  2. #2
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Massachusetts
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Day of Year

    Got this from a board, some time ago....

    =A1-DATE(YEAR(A1),1,0), where A1 = the date you are checking.

  3. #3
    3 Star Lounger baumgrenze's Avatar
    Join Date
    Feb 2001
    Location
    California, USA
    Posts
    262
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Re: Day of Year

    Thanks James!

    It worked great once I realized that I needed to reformat the new row to a 'generic' number format.

    Baumgrenze
    Baumgrenze
    Hier sind wir tief eingewurzelt.

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Baltimore, MD, Maryland, USA
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Day of Year

    This will do it for you:
    =A1-DATE(YEAR(A1)-1,12,31)[img]/w3timages/icons/yikes.gif[/img]

Posting Permissions

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