Forum Discussion
Olivier_Maltais
Oct 18, 2023Copper Contributor
Create an interval of date
Hello, I would like to have a formula to have a date interval. I want that the cell looks like this: 2023/12/31 to 2024/01/06 I would like to use a formula to set all the week of the year like this...
PeterBartholomew1
Oct 18, 2023Silver Contributor
This is the changed workbook showing both Riny_van_Eekelen 's formula and my function.
I had to change the {0,6} to {0;6} (row to column) but also concatenate the dates by column.