View original (French)

Add 3 months to a date, Formula Correction

Solved
nonossov Posted messages 638 Status Membre -  
tontong Posted messages 2575 Registration date   Status Membre 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 réponses

Réponse 1 / 4
via55 Posted messages 14730 Registration date   Status Membre Last intervention   2 755
 
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
nonossov Posted messages 638 Status Membre
 
Is it possible to have it in the form of a Formula and not a Macro??

Thank you so much.
0