Dervie financial quarter year via formula

James Clear

Board Regular
Joined
Jul 12, 2021
Messages
139
Office Version
  1. 365
  2. 2016
  3. 2013
  4. 2010
Platform
  1. Windows
I need to derive Financial year via formula .. somebody pls assist

3rd Column as mentioned below


YrMonthQuarter
2021​
JanFY 21 Q4
2021​
FebFY 21 Q4
2021​
MarFY 21 Q4
2021​
AprFY 22 Q1
2021​
MayFY 22 Q1
2021​
JunFY 22 Q1
2021​
JulFY 22 Q2
2021​
AugFY 22 Q2
2021​
SepFY 22 Q2
2021​
OctFY 22 Q3
2021​
NovFY 22 Q3
2021​
DecFY 22 Q3
2022​
JanFY 22 Q4
2022​
FebFY 22 Q4
2022​
MarFY 22 Q4
2022​
AprFY 23 Q1
2022​
MayFY 23 Q1
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
Upvote 0
Solution

Forum statistics

Threads
1,213,563
Messages
6,114,332
Members
448,566
Latest member
Nickdozaj

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top