Results 1 to 5 of 5
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Date Format & Day Of Year (2000)

    In column A I have listed the days of the year by number only, beginning with 1 and ending with 365. In column B I would like to put the day and month that corresponds to each entry in column A. Any ideas?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Date Format & Day Of Year (2000)

    I assume you want to start with this year (change as appropriate)

    =DATE(2002,1,0)+A1

    Steve

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Date Format & Day Of Year (2000)

    Thanks, Steve. I should have asked one thing further-how do you dislay just the month and day and not the year?

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Date Format & Day Of Year (2000)

    Use a custom format such as mmm d or mm d

    Andrew C

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Date Format & Day Of Year (2000)

    Thanks, Andrew.

Posting Permissions

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