Months between two dates

[Jason K]

I need to find out if the elapsed time between two dates (TRANS Date, Issue
Date) is = to or < 12 months. If it is need it to say "1st YR", and if not
"Renewal".

 

[Jacob Skaria]

Dear Jason

Use DATEDIF() with an IF()

With Start Date in A1 and end date in B1 try

=IF(DATEDIF(A1,B1,"m")>12,"Renewal","1st YR")

OR

=IF(DATEDIF(TRANS Date, Issue Date,"m")>12,"Renewal","1st YR")

If this post helps click Yes