How to calculate number of months between 2 dates

Hi,

I want to calculate number of months or years between two dates. How to use the below formula which we can use in Excel to calculate that:

=DATEDIF(Date column,TODAY(),"M")/12

If the date is 4th Jul 22 then the number of months from today should come to 0.3 and if date is 21 May 2021 then the number of months from today come to 1.3.

Please suggest the formula.

Thanks.

Find more posts tagged with

Accepted answers

All comments

Sam_Harwart

@Kamya Pamnani

Would this work?

=(TODAY() - [Date Column]@row)/30

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.