Series of 2 week dates in excel

[PamGBC]

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

[#2 · Accepted solution]

@PamGBC 

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.

[#3]

Excellent idea - thanks!