Excel - Concatenate Cells Between Two Values [duplicate]

Question

I'm trying to get all the years in between (and including) two cells indicating the start year and the end year

Such that if 2018 is the start and 2022 is the year, I'm wanting to return 2018 2019 2020 2021 2022

Likewise if 2015 was the start and 2017 was the end, return 2015 2016 2017

What would be the best way to go about this?

Answer 1

Using TEXTJOIN and SEQUENCE:

=TEXTJOIN(" ",,SEQUENCE(C5-C4+1,,C4))