James Clear
Board Regular
- Joined
- Jul 12, 2021
- Messages
- 139
- Office Version
- 365
- 2016
- 2013
- 2010
- Platform
- Windows
I need to derive Financial year via formula .. somebody pls assist
3rd Column as mentioned below
3rd Column as mentioned below
Yr | Month | Quarter |
2021 | Jan | FY 21 Q4 |
2021 | Feb | FY 21 Q4 |
2021 | Mar | FY 21 Q4 |
2021 | Apr | FY 22 Q1 |
2021 | May | FY 22 Q1 |
2021 | Jun | FY 22 Q1 |
2021 | Jul | FY 22 Q2 |
2021 | Aug | FY 22 Q2 |
2021 | Sep | FY 22 Q2 |
2021 | Oct | FY 22 Q3 |
2021 | Nov | FY 22 Q3 |
2021 | Dec | FY 22 Q3 |
2022 | Jan | FY 22 Q4 |
2022 | Feb | FY 22 Q4 |
2022 | Mar | FY 22 Q4 |
2022 | Apr | FY 23 Q1 |
2022 | May | FY 23 Q1 |