Duration formula in months

  • 1
  • 1
  • Question
  • Updated 4 months ago
  • Answered
Hello.  I am trying to display a duration formula in months.  
[Revised End Date]-[Original Start Date]
We want to see any of records that are greater than 18 months.  I see that I can choose Days or Weeks, but I don't see how to display the number of months.  
Is there an easy way to do this?  
Photo of Kim Gaston

Kim Gaston

  • 244 Points 100 badge 2x thumb
  • unsure

Posted 10 months ago

  • 1
  • 1
Well, not all months are the same length, so it’s hard to say how long a month is.


You can make a formula date field called

Original Start Date Plus 18 Months

with a formula of

AdjustMonth([Original Start Date], 18) will be 18 months after that start date.

So you could use that in a report filter.

If you really want a formula to calculate the difference in months, that is a more difficult formula.
Photo of Kim Gaston

Kim Gaston

  • 244 Points 100 badge 2x thumb
This was helpful.  Thank you so much!
Photo of Christy McBee

Christy McBee

  • 92 Points 75 badge 2x thumb
How do I create this same formula but showing the last date of the resulting month, instead of first day of month?
I think you should post a new complete question with an example. I’m not understanding your question.