Ask Your Question

is there a shortcut way to enter a descending column of consecutive dates in spreadsheet?

asked 2016-11-04 19:56:40 +0200

sunshinemonkey gravatar image

I would like to know a quick way to fill a column with consecutive dates

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2016-11-04 20:37:54 +0200

erAck gravatar image

In a cell enter start date from which to decrement, select/mark cell range to fill (including the start date), menu Sheet -> Fill Cells -> Series... from Time Unit select Day, in Increment enter -1, OK.

edit flag offensive delete link more


Thank you! This was simple enough for me to follow and easily solved my issue. Thank you so much!

sunshinemonkey gravatar imagesunshinemonkey ( 2016-11-04 21:35:33 +0200 )edit

answered 2016-11-04 20:31:28 +0200

mark_t gravatar image

updated 2016-11-04 20:32:16 +0200

For ascending dates enter the first date in cell, for example in A1, select the cell A1, click on the small black square at the bottom right of the cell cursor and drag it further down the column.

For descending dates enter the last date in A1, Then in cell A2 enter the formula =A1 - 1, then copy or drag that formula further down the column.

Above will use default date format, use menu Format, Cells and on the Numbers tab select your preferred date format.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-11-04 19:56:40 +0200

Seen: 138 times

Last updated: Nov 04 '16