Forum Discussion
Solved
Series of 2 week dates in excel
How do I fill a series of 2 week date increments in excel. ie: 8/6/2023-8/19/23 next row, same column cell = 8/20/2023-9/2/2023
I'd use two columns.
For example, enter 8/6/2023 in A2.
In A3, enter the formula =A2+14, then fill down.
In B2, enter the formula =A2+13, and fill down too.
If you wish, you can combine them in a third column:
In C2, enter the formula =TEXT(A2,"m/d/yyyy")&"-"&TEXT(B2,"m/d/yyyy") and fill down.
I'd use two columns.
For example, enter 8/6/2023 in A2.
In A3, enter the formula =A2+14, then fill down.
In B2, enter the formula =A2+13, and fill down too.
If you wish, you can combine them in a third column:
In C2, enter the formula =TEXT(A2,"m/d/yyyy")&"-"&TEXT(B2,"m/d/yyyy") and fill down.
Excellent idea - thanks!