Modifying the Formula for Date-Based Quarters to Align with NU's Fiscal Year
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
-
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! 🙂
-
Hello @Nick Korna
Thank you very much, I will look if this solves my problem.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!