I have a formula to return the quarter based on a date. I would like to add the year also.

Here is the formula, right out of this community (THANK YOU!!):

=IF(MONTH([Start Date]@row) < 4, "Q1", IF(MONTH([Start Date]@row) < 7, "Q2", IF(MONTH([Start Date]@row) < 10, "Q3", "Q4")))

Here is my awkward work around -Start Date | Start Quarter from formula above | Start Year from YEAR formula | JOIN Quarter and Year. Is there a way to do all of this in one formula?

Thanks ahead of time. 👋

Find more posts tagged with

Accepted answers

Peggy Parchert

Hello @Celia Gust

Hope you are well. Would this work - you would need to update the Date Column to what you have in your sheet:

="Q" + IF(MONTH([Date Column]@row) >= 10, "4 - ", IF(MONTH([Date Column]@row) >= 7, "3 - ", IF(MONTH([Date Column]@row) >= 4, "2 - ", "1 - "))) + YEAR([Date Column]@row)

Peggy

Celia Gust

Peggy, this works beautifully. Thank you so much. I just took out the dash, only because the excel I'm trying to replace had it formatted without a dash. Now I think I'll go watch some videos on formulas so I can be more independent. 😃 Have a great day!

All comments

Peggy Parchert

Hello @Celia Gust

Hope you are well. Would this work - you would need to update the Date Column to what you have in your sheet:

="Q" + IF(MONTH([Date Column]@row) >= 10, "4 - ", IF(MONTH([Date Column]@row) >= 7, "3 - ", IF(MONTH([Date Column]@row) >= 4, "2 - ", "1 - "))) + YEAR([Date Column]@row)

Peggy

Celia Gust

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.