Date Range Series

%3CLINGO-SUB%20id%3D%22lingo-sub-2428726%22%20slang%3D%22en-US%22%3EDate%20Range%20Series%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2428726%22%20slang%3D%22en-US%22%3E%3CP%3EWhat%20do%20I%20do%20to%20drag%20a%20date%20range%20down%20by%20row%20to%20continue%20the%20series%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei.e.%26nbsp%3B%3C%2FP%3E%3CP%3E1%2F1%2F2021%20-%201%2F7%2F2021%3C%2FP%3E%3CP%3E*Then%20whatever%20action%20I%20need%20to%20do%20to%20result%20in%20subsequent%20rows%20being%3A%3C%2FP%3E%3CP%3E1%2F8%2F2021%20-%201%2F14%2F2021%3C%2FP%3E%3CP%3E1%2F15%2F2021%20-%201%2F21%2F2021%3C%2FP%3E%3CP%3E1%2F22%2F2021%20-%201%2F28%2F2021%3C%2FP%3E%3CP%3E1%2F29%2F2021%20-%202%2F4%2F2021%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2428726%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2428772%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20Range%20Series%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2428772%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1074144%22%20target%3D%22_blank%22%3E%40hannahhoward%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'd%20use%20two%20columns.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20example%2C%20enter%20the%20start%20date%201%2F1%2F2021%20in%20A1.%3C%2FP%3E%0A%3CP%3EIn%20A2%2C%20enter%20the%20formula%20%3D%20A1%2B7%3C%2FP%3E%0A%3CP%3EFill%20or%20copy%20down%20from%20A2%20as%20far%20as%20needed.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20B1%2C%20enter%20the%20formula%20%3DTEXT(A1%2C%22m%2Fd%2Fyyyy%22)%26amp%3B%22%20-%20%22%26amp%3BTEXT(A1%2B6%2C%22m%2Fd%2Fyyyy%22)%3C%2FP%3E%0A%3CP%3EFill%20or%20copy%20down%20from%20B2%20to%20the%20end%20of%20the%20data.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20might%20hide%20column%20A%20now%2C%20if%20you%20wish.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

What do I do to drag a date range down by row to continue the series?

 

i.e. 

1/1/2021 - 1/7/2021

*Then whatever action I need to do to result in subsequent rows being:

1/8/2021 - 1/14/2021

1/15/2021 - 1/21/2021

1/22/2021 - 1/28/2021

1/29/2021 - 2/4/2021

 

 

 

1 Reply

@hannahhoward 

I'd use two columns.

 

For example, enter the start date 1/1/2021 in A1.

In A2, enter the formula = A1+7

Fill or copy down from A2 as far as needed.

 

In B1, enter the formula =TEXT(A1,"m/d/yyyy")&" - "&TEXT(A1+6,"m/d/yyyy")

Fill or copy down from B2 to the end of the data.

 

You might hide column A now, if you wish.