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).
2 Replies
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
