Forum Discussion
clndeakhotmailcom
Aug 07, 2022Copper Contributor
Excel 365 Autofill
How do I autofill by adding one day to previous day. ie. 05.08.22 is the last date in cell and I want to autofill down with 06.08.22, 07.08.22 etc
Norman_Glenn
Aug 07, 2022Brass Contributor
For me I just put date in were i need it then then on bottom right corner of that cell their a little square, I just left double click on it and it autofill's down till next empty cell beside the date that will contain the date. can click on first date and right click and format cell then date and use what way you would like date to show.