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
Riny_van_Eekelen
Aug 07, 2022Platinum Contributor
clndeakhotmailcom If the first cell is a real date you can just drag it down and Excel will automatically increment the date by one day for every row.
clndeakhotmailcom
Aug 13, 2022Copper Contributor
Thanks, sorted