Need help on Formula

I am writing this formula in column to calculate the Quarter (Q1,Q2,Q3,Q4) from a date and getting results like (Q1,Q2,Q3,Q4) without the year. Can someone please help me with getting this value Q4 - 2022, Q1- 2023 , Q2 - 2023 etc.

Thanks in advance!

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

Find more posts tagged with

Formulas

Accepted answers

Kelly P.

@Parvez Khan

You could use something like this:

=IFERROR(IF(OR(MONTH(Date@row) = 1, MONTH(Date@row) = 2, MONTH(Date@row) = 3), "Q1" + " " + YEAR(Date@row), IF(OR(MONTH(Date@row) = 4, MONTH(Date@row) = 4, MONTH(Date@row) = 6), "Q2" + " " + YEAR(Date@row), IF(OR(MONTH(Date@row) = 7, MONTH(Date@row) = 8, MONTH(Date@row) = 9), "Q3" + " " + YEAR(Date@row), IF(OR(MONTH(Date@row) = 10, MONTH(Date@row) = 11, MONTH(Date@row) = 12), "Q4") + " " + YEAR(Date@row)))), "")

Hope this helps!

All comments

Kelly P.

@Parvez Khan

You could use something like this:

Hope this helps!

Parvez Khan

Thanks a lot Kelly. It is now working as expected. One more question, when I changed the Date to Reporting Start Date this is not working. I am now using the below query. Not sure if the issue is the spaces in the "Reporting Start Date" column.

=IFERROR(IF(OR(MONTH(Reporting Start Date@row) = 1, MONTH(Reporting Start Date@row) = 2, MONTH(Reporting Start Date@row) = 3), "Q1" + " " + YEAR(Reporting Start Date@row), IF(OR(MONTH(Reporting Start Date@row) = 4, MONTH(Reporting Start Date@row) = 4, MONTH(Reporting Start Date@row) = 6), "Q2" + " " + YEAR(Reporting Start Date@row), IF(OR(MONTH(Reporting Start Date@row) = 7, MONTH(Reporting Start Date@row) = 8, MONTH(Reporting Start Date@row) = 9), "Q3" + " " + YEAR(Reporting Start Date@row), IF(OR(MONTH(Reporting Start Date@row) = 10, MONTH(Reporting Start Date@row) = 11, MONTH(Reporting Start Date@row) = 12), "Q4") + " " + YEAR(Reporting Start Date@row)))), "")

Kelly P.

@Parvez Khan

You'll need to put brackets around the column names (column names with spaces or digits need brackets).

=IFERROR(IF(MONTH([Reporting Start Date]@row) = 1 etc.

Does that work for you?

Parvez Khan

Thank you once again for your help. It is working as expected!

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.