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

Options
P.mengade
P.mengade ✭✭
edited 09/25/23 in Formulas and Functions

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 

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!