Add 1 year

[Muthukrishnan V]

Book2.xlsx
	A	B	C	D
1	Excel 365
2
3	YYYY-YY		YYYY-YY
4	2015-16		2016-17	If A4=2015-16, C4 should be 2016-17
5	2018-19		2019-20
6	2021-22		2022-23
7
8	Formula request for C4:C6
Sheet1

Thank you for yourkind help

 

[Sufiyan97]

Try

Book2
	A	B	C	D	E
1	Excel 365
2
3	YYYY-YY		YYYY-YY
4	2015-16		2016-17	If A4=2015-16, C4 should be 2016-17
5	2018-19		2019-20
6	2021-22		2022-23
7
8	Formula request for C4:C6
9
10
Sheet1

Cell Formulas
Range	Formula
C4:C6	C4	=TEXTJOIN("-",TRUE,TEXTSPLIT(A4,"-")+1)

 

[Muthukrishnan V]

Thank you sir, works great.
I am grateful to our forum.

 

[Sufiyan97]

You're welcome.
Happy to help.