How do I only get the 25, 26, 27, etc out of 2025, 2026, 2027?

I need to pull out the last 3rd and 4th characters of a long year format CCYY where I only pull out the YY. So, in my example, I need to find the year 25 out of 2025. 26 out of the year 2026, 27 out of the year 2027 and so on. Basically ignore the first two characters of the long year 2025 so I will only be seeing the 25 out of the year.

Does anyone have an idea on how to do this?

Thank you!

Find more posts tagged with

Formulas

Accepted answers

Adam Murphy

Hi @mtuccillo,

I would use the RIGHT function and specify 2 characters. Something like this: =RIGHT(YEAR(TODAY()), 2)

Hope this helps!

All comments

Adam Murphy

Hi @mtuccillo,

I would use the RIGHT function and specify 2 characters. Something like this: =RIGHT(YEAR(TODAY()), 2)

Hope this helps!

mtuccillo

Thank you!

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.