View original (French)

FIND A DATE WITH THE DAY AND THE YEAR

Solved
TURBO13 Posted messages 2 Status Member -  
 macrv -
Hello,
My issue is as follows:

In G27 I have the year AAAA
in G29 I have the day number QQQ

With these two cells, I would like to get the exact day and date in I29, while taking leap years into account.

Thank you in advance.

3 answers

  1.
    ccm81 Posted messages 11033 Status Member 2 434
     
    Hello

    try with I29= DATE(G27,1,1)+G29-1

    Best regards
    1
    1. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
       
      Hello ccm81

      I’m a bit late, as usual :-)
      but I still highlight the minus 1 needed in the formula so as not to shift by one day!
      try with G29 = 1 and you land on January 2

      or:
      =DATE(G27-1;31;12)+G29

      have a good weekend
      0
    2. macrv
       
      It works the first time. A big thank you.
      0