Dynamic Date Column Headers

[jbfrank]

I'm trying to build a financial report that automatically pulls in data based on a date range...but the date range can change. For simplicity, let's just use 'years'. Here's what I have:

A1: 2019 (this is the starting year)
A2: 5 (this is the number of incremental years I'd like to view)

Desired result:

Starting in A5, I'd like to have '2019' with each consecutive year showing up in B5, C5, D5 and E5. Easy enough.

I'm struggling to make this range dynamic. So, if I have 7 incremental years I'd like to view, then I'd like to have those show up in B5:G5.

I'm open to other (and probably better) options on doing this as well.

Really appreciate the help!

 

[Scott T]

Copy across to cover the max number of years you could want.

Book1
	A	B	C	D	E	F
1	2019
2	5
3
4
5	2019	2020	2021	2022	2023
Sheet1

Cell Formulas
Range	Formula
A5	=A1
B5	=IF(COLUMNS($A$5:B5)<=$A$2,A5+1,"")
C5	=IF(COLUMNS($A$5:C5)<=$A$2,B5+1,"")
D5	=IF(COLUMNS($A$5:D5)<=$A$2,C5+1,"")
E5	=IF(COLUMNS($A$5:E5)<=$A$2,D5+1,"")
F5	=IF(COLUMNS($A$5:F5)<=$A$2,E5+1,"")

 

[jbfrank]

This works perfectly, Scott. Thank you!