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

Options
edited 09/25/23

Hi

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

• ✭✭✭✭✭✭
Options

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! 🙂

• Options

Hello @Nick Korna

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

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!