Forum Discussion
Solved
Quickly creating a list of date ranges
Is there a function or way to quickly create a list of the weeks? What I'm going for kinda looks like: Jan 1-Jan 7 Jan 8-Jan 14 Jan 15-Jan 21 etc Thanks!
Enter the following formula in a cell:
=LET(s, SEQUENCE(52, , DATE(2024, 1, 1), 7), TEXT(s, "mmm d")&"-"&TEXT(s+6, "mmm d"))
It will spill to 52 cells (you can change this number in the formula).
Enter the following formula in a cell:
=LET(s, SEQUENCE(52, , DATE(2024, 1, 1), 7), TEXT(s, "mmm d")&"-"&TEXT(s+6, "mmm d"))
It will spill to 52 cells (you can change this number in the formula).
Saved me so much time thank you T_T