We were trying to use Month() calculation to set reminder. However, it is not returning the result as intended.

We have a startDate field and would like to add exact 2 months to startDate as reminder. Intended results are:

startDate > reminderDate

19/03/2011 > 18/05/2011

01/11/2011 > 31/12/2012

30/11/2011 > 29/01/2012

31/12/2011 > 29/02/2012

01/01/2012 > 29/02/2012

In remWe used Date(Month(startDate)+2; Day(startDate); Year(startDate))-1

Try =

 

Let ( [
newDate = Date ( Month ( StartDate ) + 2 ; Day ( StartDate ) ; Year ( StartDate ) ) - 1  ;
limit = Date ( Month ( StartDate ) + 3 ; 0 ; Year ( StartDate ) )
] ;
Min ( newDate ; limit )
)

Hi,

 

Sorry, I used my tiny iphone to compose this message and accidentally pressed on the Post button before I could finish my message.

 

Thanks god that you understand my question and it has been resolved.

 

Many thanks.