Forum Discussion
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
when I fill down using in the handle in bottom right of cell, the date is only filled down by adding the year, not one day. I am doing Edit, Fill, Series with column, Date, Day buttons selected and Step value 1.
I am using Excel for Mac, v 16.63.1 and am a 365 subscriber
From your description it sounds as if Excel has only recognised your data as text and not a numerical date. As a 365 user, you do have an alternative to fill down, namely an array formula. For example
= SEQUENCE(100000,,startDate)will give a column of 100000 days without any filling down. Then again, you may not be especially interested in the year 2296!