Auto Fill Financial Periods from given start and end date

[TN2022]

I'm trying to auto fill given financial periods based on start and end dates of agreements, this will then allow me to prorata the contract value.

Contract Period
A1 Start: 15/02/2020
A2 End: 14/02/2022

Auto Fill =
A3 FY19/20 Start = 01/02/2020
A4 FY19/20 End = 31/03/2020

A5 FY20/21 Start = 01/04/2020
A6 FY20/21 End = 31/03/2021

A7 FY21/22 Start = 01/04/2021
A8 FY21/22 End = 14/02/2022

A9 FY22/23 Start = BLANK
A10 FY22/23 End = BLANK

I've been stuck on this for days, any help will be much appreciated. Apologies I can't upload a sheet, currently on my personal mobile.

 

[BSALV]

C:D are a little different, but then you can copy E:F to G:H, I:J, etc

Map1
	A	B	C	D	E	F	G	H	I	J	K	L
1	15-02-20	14-02-24	01-02-20	31-03-20	01-04-20	31-03-21	01-04-21	31-03-22	01-04-22	31-03-23	01-04-23	14-02-24
2	15-03-20	14-02-24	01-03-20	31-03-20	01-04-20	31-03-21	01-04-21	31-03-22	01-04-22	31-03-23	01-04-23	14-02-24
3	15-04-20	14-02-24	01-04-20	31-03-21	01-04-21	31-03-22	01-04-22	31-03-23	01-04-23	14-02-24	-	-
4	15-05-20	14-02-24	01-05-20	31-03-21	01-04-21	31-03-22	01-04-22	31-03-23	01-04-23	14-02-24	-	-
5	15-06-20	14-02-24	01-06-20	31-03-21	01-04-21	31-03-22	01-04-22	31-03-23	01-04-23	14-02-24	-	-
6	15-07-20	14-02-24	01-07-20	31-03-21	01-04-21	31-03-22	01-04-22	31-03-23	01-04-23	14-02-24	-	-
7	15-08-20	14-02-24	01-08-20	31-03-21	01-04-21	31-03-22	01-04-22	31-03-23	01-04-23	14-02-24	-	-
8	15-09-20	14-02-24	01-09-20	31-03-21	01-04-21	31-03-22	01-04-22	31-03-23	01-04-23	14-02-24	-	-
9	15-10-20	14-02-24	01-10-20	31-03-21	01-04-21	31-03-22	01-04-22	31-03-23	01-04-23	14-02-24	-	-
10	15-11-20	14-02-24	01-11-20	31-03-21	01-04-21	31-03-22	01-04-22	31-03-23	01-04-23	14-02-24	-	-
11	15-12-20	14-02-24	01-12-20	31-03-21	01-04-21	31-03-22	01-04-22	31-03-23	01-04-23	14-02-24	-	-
12	15-01-21	14-02-24	01-01-21	31-03-21	01-04-21	31-03-22	01-04-22	31-03-23	01-04-23	14-02-24	-	-
Blad1

Cell Formulas
Range	Formula
C1:C12	C1	=EOMONTH(A1,-1)+1
D1:D12	D1	=MIN(EDATE(C1,4-MONTH(C1)+((MONTH(C1)>3)*12))-1,$B1)
E1:E12,G1:G12,I1:I12,K1:K12	E1	=IF(D1+1<=$B1,D1+1,"-")
F1:F12,H1:H12,J1:J12,L1:L12	F1	=IF(ISNUMBER(E1),MIN($B1,EDATE(E1,12)-1),"-")
A2:A12	A2	=EDATE(A1,1)
B2:B12	B2	=+B1

 

[TN2022]

Wow, thanks I'll give this a go tomorrow and let you know how I get on. Looks amazing!

 

[TN2022]

C:D are a little different, but then you can copy E:F to G:H, I:J, etc

Map1
	A	B	C	D	E	F	G	H	I	J	K	L
1	15-02-20	14-02-24	01-02-20	31-03-20	01-04-20	31-03-21	01-04-21	31-03-22	01-04-22	31-03-23	01-04-23	14-02-24
2	15-03-20	14-02-24	01-03-20	31-03-20	01-04-20	31-03-21	01-04-21	31-03-22	01-04-22	31-03-23	01-04-23	14-02-24
3	15-04-20	14-02-24	01-04-20	31-03-21	01-04-21	31-03-22	01-04-22	31-03-23	01-04-23	14-02-24	-	-
4	15-05-20	14-02-24	01-05-20	31-03-21	01-04-21	31-03-22	01-04-22	31-03-23	01-04-23	14-02-24	-	-
5	15-06-20	14-02-24	01-06-20	31-03-21	01-04-21	31-03-22	01-04-22	31-03-23	01-04-23	14-02-24	-	-
6	15-07-20	14-02-24	01-07-20	31-03-21	01-04-21	31-03-22	01-04-22	31-03-23	01-04-23	14-02-24	-	-
7	15-08-20	14-02-24	01-08-20	31-03-21	01-04-21	31-03-22	01-04-22	31-03-23	01-04-23	14-02-24	-	-
8	15-09-20	14-02-24	01-09-20	31-03-21	01-04-21	31-03-22	01-04-22	31-03-23	01-04-23	14-02-24	-	-
9	15-10-20	14-02-24	01-10-20	31-03-21	01-04-21	31-03-22	01-04-22	31-03-23	01-04-23	14-02-24	-	-
10	15-11-20	14-02-24	01-11-20	31-03-21	01-04-21	31-03-22	01-04-22	31-03-23	01-04-23	14-02-24	-	-
11	15-12-20	14-02-24	01-12-20	31-03-21	01-04-21	31-03-22	01-04-22	31-03-23	01-04-23	14-02-24	-	-
12	15-01-21	14-02-24	01-01-21	31-03-21	01-04-21	31-03-22	01-04-22	31-03-23	01-04-23	14-02-24	-	-
Blad1

Cell Formulas
Range	Formula
C1:C12	C1	=EOMONTH(A1,-1)+1
D1:D12	D1	=MIN(EDATE(C1,4-MONTH(C1)+((MONTH(C1)>3)*12))-1,$B1)
E1:E12,G1:G12,I1:I12,K1:K12	E1	=IF(D1+1<=$B1,D1+1,"-")
F1:F12,H1:H12,J1:J12,L1:L12	F1	=IF(ISNUMBER(E1),MIN($B1,EDATE(E1,12)-1),"-")
A2:A12	A2	=EDATE(A1,1)
B2:B12	B2	=+B1

Great stuff, thanks so much for your help, works perfectly