View original (French)

Add months to a date

petitcuir Posted messages 2 Status Member -  
petitcuir Posted messages 2 Status Member -
Hello, I would like to add 29 months and 7 weeks to the date of January 1, 2015. How do I do that??
Thank you

4 answers

  1.
    DjiDji59430 Posted messages 4278 Registration date   Status Member Last intervention   717
     
    Hello,

    =EDATE(DATE(2015,1,1),29)+(7*7)

    =>20/07/2017
    2