Dynamic Array Formula Query - Dates

Hi,

Not quite sure how to title this question.

I am trying to derive some helper data from dates using the new Dynamic Arrays functions in O365.

I am trying to assign a number to every month in a financial year. That is, all months in financial year 2020 to be 1, 2021 to be 2, 2023 to be 3, etc.

I need this to be a dynamic array to be compatible with the rest of the spreadsheet.
Attached is a sample file with the problem. I need a formula for cell G10. The desired results are highlighted in green.

Eg.
Date 30/06/2020 31/07/2020 31/08/2020 etc
Financial Yr 2020 2021 2021
Financial Model Yr 1 2 2

Any suggestions?

Brilliant!! Thanks Bo_Ry.

2 solutions that work. I'll use the 1st one for it's simplicity.

Much appreciated.