View original (French)

Find the date from the day number

Solved
Toulouse31240 Posted messages 18 Status Member -  
Toulouse31240 Posted messages 18 Status Member -
Hello everyone,

I can't use the DATE function to find a date based on the day number of the year.

For example, 283 = October 10, 2011

Thank you in advance for your help..

Configuration: Windows XP SP3 / Firefox 7.0.1/ EXCEL 2002 SP3

2 answers

  1.
    michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   3 320
     
    Hello

    the year in A1 (e.g.: 2011)
    the day in B1 (283)
    =DATE(A1;1;1)+B1-1
    --
    Michel
    0
  2. Toulouse31240 Posted messages 18 Status Member
     
    'tin, it works! :-) Thanks.

    Well, it's annoying, but as usual, you just have to ask a carefully formulated question to find the answer yourself...

    January 1, 2011, is serial number 40544 (found by changing the DATE cell format to NUMBER) so I wrote "=40543 + A1," A1 being the ordinal date of the year, all in DATE format, which gives me 40543 + 283 = 40826, or in DATE format "10/10/2011."

    There you go...
    Thanks for your quick response, Michel.
    0