Modifying the Formula for Date-Based Quarters to Align with NU's Fiscal Year

I'm using this formula: ="Q" + INT((MONTH(Date@row) + 2) / 3) to calculate quarters based on dates. However, our fiscal year at NU runs from July 1st to June 30th.

Here's the adjustment needed:

July 1st to Sept 30th should be Q1.

Oct 1st to Dec 31st should be Q2.

Jan 1st to Mar 31st should be Q3.

Apr 1st to Jun 30th should be Q4.

I need help with adapting this formula to match our fiscal year? Your advice is appreciated!

Thank you,

Pratiksha

Find more posts tagged with

Accepted answers

All comments

Nick Korna

Hi @P.mengade,

This should do what you're after:

="Q" + (IF(MONTH(Date@row) <= 3, 3, IF(MONTH(Date@row) <= 6, 4, IF(MONTH(Date@row) <= 9, 1, 2))))

Hope this helps, but if you've any problems/questions then just post! 🙂

P.mengade

Hello @Nick Korna

Thank you very much, I will look if this solves my problem.

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.