setting up weekly data

Question

I have sales data that was gather in 2025 and it was base on a 5day workweek. for example we have it as Jan 06-10, Jan 13-17, is there a formula to calculate the date just like it so that we don't write the data every time and just do a flash fill and only worry about plugging in the number.

Answer 1

Yep - you can generate the 5-day workweek ranges automatically with a formula instead of typing Jan 06-10, Jan 13-17, etc.

Assuming you want the first workweek of 2025 to start on Monday Jan 6, 2025, enter this in the first cell:

=TEXT(DATE(2025,1,6),"mmm dd")&"-"&TEXT(DATE(2025,1,6)+4,"dd")

That returns: Jan 06-10

Then in the next row use:

=TEXT(DATE(2025,1,6)+(ROW(A1)-1)*7,"mmm dd")&"-"&TEXT(DATE(2025,1,6)+(ROW(A1)-1)*7+4,"dd")

Copy this down. Each row will move forward by 7 days and always show a Monday–Friday range.

If your first formula starts in row 2 instead of row 1, adjust ROW(A1) to match, for example:

=TEXT(DATE(2025,1,6)+(ROW(A2)-2)*7,"mmm dd")&"-"&TEXT(DATE(2025,1,6)+(ROW(A2)-2)*7+4,"dd")

Now you only need to drag down and enter the sales numbers beside it.

---

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin