Thanks alot, it worked, and also brought to my attention some other stuff

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"Jason K" wrote:

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".