Advancing year by +1 from a =text(a1,"YYYY") formula

[shasbrooke]

I have a date formatted in cell A1 with a value of 01/31/2023. In cell B1 I have =text(a1,"YYYY") resulting in "2023" in cell B1. In cells C1:C50 I would like 2024, 2025, 2026, etc. similarly in a text string as B1. Can't seem to get it to work. The tries I have made so far keep returning "1905". Any help is appreciated.

 

[Phuoc]

Try this in C1

=B1+1

in C2:

=C1+1

 

[shasbrooke]

Try this in C1

=B1+1

in C2:

=C1+1

C1 still giving me 1905 using =B1+1

 

[Phuoc]

It works for me.

Book1
	A	B	C
1	1/31/2023	2023	2024
2			2025
3			2026
4			2027
5			2028
6			2029
7			2030
8			2031
9			2032
10			2033
11			2034
12			2035
13			2036
Sheet1

Cell Formulas
Range	Formula
B1	B1	=TEXT(A1,"YYYY")
C1	C1	=B1+1
C2:C13	C2	=C1+1

 

[shasbrooke]

It works for me.

Book1
	A	B	C
1	1/31/2023	2023	2024
2			2025
3			2026
4			2027
5			2028
6			2029
7			2030
8			2031
9			2032
10			2033
11			2034
12			2035
13			2036
Sheet1

Cell Formulas
Range	Formula
B1	B1	=TEXT(A1,"YYYY")
C1	C1	=B1+1
C2:C13	C2	=C1+1

Perhaps it is something else in my thread of dates/formulas. I tried to simplify the issue in the original post, but maybe it is something in the formulas leading up to what I stated was A1 previously. Here is the entire flow, with E3 being the date upon which I then calc =TEXT(E3,"YYYY") in F3, which results in 2023. I want to add one year to that in cell G3. Sorry that the initial post was incomplete information:

 

[Phuoc]

Like this?

Book1
	A	B	C	D	E	F	G
1
2
3			6/15/1974			1974	1975
Sheet1

Cell Formulas
Range	Formula
F3	F3	=YEAR(C3)
G3	G3	=F3+1

 

[shasbrooke]

Like this?

Book1
	A	B	C	D	E	F	G
1
2
3			6/15/1974			1974	1975
Sheet1

Cell Formulas
Range	Formula
F3	F3	=YEAR(C3)
G3	G3	=F3+1

Thank you, Phuoc. I made some tweaks to some of the other formulas and incorporated your suggestion and all is working well now.