arrays - how to distribute a number into numbers of cells?

Question

I have a sheet for the employees leaves so for example if:

Employee A takes Annual leave for 4 days starting 1/1/2021 I want to distribute the days into cells for these days to be like this:

A | 4 | 1/1/2021 1/1/2021 2/1/2021 3/1/2021 4/1/2021

I want to have each day date into a single cell.

any idea how to achieve that, please

标签： arraysgoogle-sheets

Answer 1

尝试：

=INDEX(TEXT(TRANSPOSE(ROW(INDIRECT(B2&":"&B2+A2-1))), "d/m/yyyy"))