calculate number of full months between start and end dates

I'm looking for a formula that will calculate the number of full months between 2 dates that will be used for calculating a goal amount by multiplying a monthly amount x the number of full months (partial months are prorated). In my example, I'm using

=ROUNDDOWN((([End Date]@row + 1) - [Start Date]@row) / 30.425, 0)

It seems if I change the 30.425 to another value such as 30 or 30.25 or 30.4325, it causes some of my other calculations to be incorrect but 30.425 doesn't seem to work for those highlighted.

Any help would be greatly appreciated!

Find more posts tagged with

Formulas

Accepted answers

All comments

Cory Page

I actually had to do something similar today and used the below style formula to find the months. You may need to add one or subtract one but It seems to be what I needed hopefully it helps you as well. Make sure that ( in front of the year otherwise it may not work.

=(YEAR([End Date]@row) - YEAR([Start Date]@row)) * 12 + MONTH([End Date]@row) - MONTH([Start Date]@row)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.