Incrementing cell value in time format

[toufiqsap]

Hi Floks,

I am writing code for the incrementing the A1 cell value till the cell A2 and display it in A3(time format).

EX: I have a value of in cell A1= 2020.01 and in cell A2= 5 YEARS.

A3 cell should display like.

2021.01,2022.01,2023.01,2024.01,2025.01

 

[Phuoc]

TEXTJOIN.xlsm
	A
1	2020
2	5
3	2021.1, 2022.1, 2023.1, 2024.1, 2025.1
Sheet4

Cell Formulas
Range	Formula
A3	A3	=TEXTJOIN(", ",1,A1+SEQUENCE(A2) &".1")
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[toufiqsap]

TEXTJOIN.xlsm
	A
1	2020
2	5
3	2021.1, 2022.1, 2023.1, 2024.1, 2025.1
Sheet4

Cell Formulas
Range	Formula
A3	A3	=TEXTJOIN(", ",1,A1+SEQUENCE(A2) &".1")
Press CTRL+SHIFT+ENTER to enter array formulas.

A2
Hey thanks for the reply,

But here my A1 and A2 are dynamic(User will enter input) it will be sometimes A1=2025.12 and A2= 10 years. So i want to achive this through dynamic(Macro).

 

[Phuoc]

Try change to

TEXTJOIN.xlsm
	A
1	2025.12
2	10
3	2026.12, 2027.12, 2028.12, 2029.12, 2030.12, 2031.12, 2032.12, 2033.12, 2034.12, 2035.12
Sheet4

Cell Formulas
Range	Formula
A3	A3	=TEXTJOIN(", ",1,A1+SEQUENCE(A2))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[toufiqsap]

Try change to

TEXTJOIN.xlsm
	A
1	2025.12
2	10
3	2026.12, 2027.12, 2028.12, 2029.12, 2030.12, 2031.12, 2032.12, 2033.12, 2034.12, 2035.12
Sheet4

Cell Formulas
Range	Formula
A3	A3	=TEXTJOIN(", ",1,A1+SEQUENCE(A2))
Press CTRL+SHIFT+ENTER to enter array formulas.

Hey Man,

Bingo.! thank you so much man.