Extracting Month and Year from a date range

Hello, Smartsheet community,

I am trying to create a Month and year (MM/YYYY format) from a date range, for example, 02/09/2025-02/15/2025, where based on the last date of the range, it will be me 02/2025 format. I tried using the RIGHT function to get the year and month, but I can't seem to figure it out. Any suggestion would be greatly appreciated!

Find more posts tagged with

Accepted answers

Paul Newcome

Give this a try:

=MID([Column Name]@row, 12, 2) + "/" + RIGHT([Column Name]@row, 4)

All comments

Paul Newcome

Is it possible you would have two different months in there? If so, how would you want to manage that?

Helen Rim

Yes, if the date range was 01/26/2025-02/01/2025 with two different months, I would always want to use the ending date in the range, so in this case, it would be 02/2025.

Paul Newcome

Give this a try:

=MID([Column Name]@row, 12, 2) + "/" + RIGHT([Column Name]@row, 4)

Helen Rim

That worked beautifully! Thank you so much!

Paul Newcome

Happy to help. 👍️

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.