Excel, Copying rows with dates.

%3CLINGO-SUB%20id%3D%22lingo-sub-1460047%22%20slang%3D%22en-US%22%3EExcel%2C%20Copying%20rows%20with%20dates.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1460047%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20copy%20a%20row%20to%20the%20row%20below%2C%20I%20would%20like%20to%20use%20the%20COPY%20then%20PASTE%20commands.%26nbsp%3B%20When%20I%20do%20that%20the%20dates%20do%20not%20increment.%26nbsp%3B%20The%20only%20way%20to%20make%20the%20dates%20increment%20is%20to%20mark%20the%20row%20and%20then%20drag%20it%2C%20using%20my%20touchpad%2C%20to%20the%20row%20below.%26nbsp%3B%20I%20would%20prefer%20not%20to%20use%20my%20touchpad.%20Is%20there%20a%20way%20to%20Ctrl-C%20then%20Ctrl-V%20and%20get%20the%20dates%20to%20increment%3F%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1460047%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

When I copy a row to the row below, I would like to use the COPY then PASTE commands.  When I do that the dates do not increment.  The only way to make the dates increment is to mark the row and then drag it, using my touchpad, to the row below.  I would prefer not to use my touchpad. Is there a way to Ctrl-C then Ctrl-V and get the dates to increment? Thanks.

1 Reply
Highlighted

@arniehalp I dare to say that you can't. But, for example, if your first date is in A1 you could put a formula in A2 that calculates the next date like this:

 

=A1+1

 

 If you then copy row 2 and paste it in row 3, the date will increment.