Months between two dates
Hey everyone! I am hoping you can help me. I am trying to calculate the number of months between a date and today. For example, if the date is 01/01/22 and today is 09/20/22 I need a formula to show 8 months.
The problem I am having is some of the beginning dates are in another year. Based on the formula I currently am using I am receiving negative months. An example of this is starting date is 12/13/21 and based on today's date (9/20/22) I am getting -3 months.
The formula I am using is MONTH(TODAY())-[Start Date]
Any help would be appreciated!
Help Article Resources
Check out the Formula Handbook template!