View original (French)

Add 3 months to a date, Formula Correction

Solved
nonossov Posted messages 638 Status Member -  
tontong Posted messages 2575 Registration date   Status Member Last intervention   -
Hello my friends,

I have this macro that adds text to a date: 

=+"Deposit to be paid on "&TEXT(E3;" mmm aaaa")


In E3 I have the date.

My question: how can I automatically add 3 months to this date without changing cell E3?

Thank you my friends.

4 answers

  1.
    via55 Posted messages 14393 Registration date   Status Member Last intervention   2 759
     
    Hello

    To put the result, for example in G3: 
    dateinit = Range("E3") Range("G3") = "Deposit to be paid in " & Format(DateAdd("m", 3, dateinit), "mmm yyyy")


    Best regards
    Via

    --
    "Imagination is more important than knowledge." A. Einstein
    0
    1. nonossov Posted messages 638 Status Member
       
      Is it possible to have it in the form of a Formula and not a Macro??

      Thank you so much.
      0