Ask Your Question

fill all 365 days in 365 cells automatically

asked 2020-02-15 08:21:01 +0100

makarena gravatar image

i wanna all 365 days in 365 cells automatically


take for example cell A1 with 01.01.1999 and next cells in A column should take A1+1 but so that i dont have to manually type in =A1+1, it should take A1 and automatically change it to A2 and so on

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-02-15 08:34:23 +0100

robleyd gravatar image

Enter the first date in the first cell of the series. Click in another cell. Grab the little black handle on the bottom right of the first cell with the date in it and drag it down as far as you need. This is called Autofill - see the Help. For other ways, see filling;cells, automatically in the Help.

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. That will help other people with the same question.

In case you need clarification, edit your question (not an answer) or comment the relevant answer.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-02-15 08:21:01 +0100

Seen: 30 times

Last updated: Feb 15