Months between two dates

  • Thread starter Thread starter Jason K
  • Start date Start date
J

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expanding Date formula 1
Excel Message box with days of month & date. 1
rounding a month upwards , after using an =datedif fomula 3
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Excel Help with dates 2
Days Since Report Was Run 1
If statement with dates 0
Calc Number of Months PER YEAR Between Dates 2

Back
Top