i wanna all 365 days in 365 cells automatically
or
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
i wanna all 365 days in 365 cells automatically
or
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
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.