Autocomplete between two values?

Question

excel

There is a price list of auto parts in csv format. Automotive theme. I have two columns:

1. in one is the year of the start of production of the car model,
   
2. in another year, the release of the car model is completed (or an empty field if the model is in production).
   

I need to collect these release years in one more column in the full range from and to (and if the value is empty, then specify the value 2022):

Example:

Column (start year), value in the line: 2005
Column (end year), value in line: 2009 It is

necessary to form a type column for each line: 2005, 2006, 2007, 2008, 2009.

If the year of completion is empty in the cell, then specify: 2022.

In general, so that values ​​​​separated by commas are generated in the year of issue column.

Is it possible to do this task with some macro or function? Or is there some alternative possible?

(I am compiling a price list for uploading to woocomerce.)

Answer 1

For Excel with little checks and a year based on the current date.
Formula in cell C2:

=
ЕСЛИ(
    ИЛИ(И(A2="";B2="");И(B2<>"";B2<A2))
    ;"?!"
    ;ЕСЛИОШИБКА(
        ОБЪЕДИНИТЬ(
            ", "
            ;1
            ;ПОСЛЕД(
                1
                ;ЕСЛИ(
                    B2=""
                    ;ГОД(СЕГОДНЯ())-A2+1
                    ;B2-A2+1
                )
                ;A2
            )
        )
        ;"-"
    )
)

For Google Sheets , the formula in cell C2 is:

=ЕСЛИ(ИЛИ(И(A2="";B2="");И(B2<>"";B2<A2));"?!";ЕСЛИОШИБКА(JOIN(", ";SEQUENCE(1;ЕСЛИ(B2="";ГОД(СЕГОДНЯ())-A2+1;B2-A2+1);A2));"–"))