Financial year indicator

[gerudman]

I'm like to estimate a financial year number (from 1 onwards) for a selected date range. Getting the financial year is fairly easy, but getting this into a generic 1, 2, 3, 4 etc range is still baffling me. The first year seems easy with purely a if <7 = previous FY otherwise +1, but there after it gets a bit tricky. Can someone please shed some light on how this can be done best?

Month Expected FY
Feb-16 1 (first one with always be fixed as 1)
Mar-16 1
Apr-16 1
May-16 1
Jun-16 1
Jul-16 2
Aug-16 2
Sep-16 2
Oct-16 2
Nov-16 2
Dec-16 2
Jan-17 2
Feb-17 2
Mar-17 2
Apr-17 2
May-17 2
Jun-17 2
Jul-17 3
Aug-17 3

[samba_ravi]

if your data is in column a try below formula

Please Login or Register  to view this content.

extend the range A$1:A$19 as per your needs

[samba_ravi]

or
b1

Please Login or Register  to view this content.

try this and copy towards down