Forum Discussion
Solved
How to auto-populate the weeks of the year
How to auto-populate the weeks of the year with their beginning and ending date (Ex: 1/2 - 1/8) and autofill
Hello cmoulthrop,
sorry for misunderstanding your question, not really good in English.
anyway... based on your image.the sample is on the attached.
The same formula as that introduced by Rodrigo_ but optimised for readability in Excel 365
= LET(
counter, SEQUENCE(1, weeks, weeks-1, -1),
startweek, TEXT(start + 7*counter, "m/d"),
endweek, TEXT(start + 7*counter+6, "m/d"),
startweek & " - " & endweek
)