Forum Discussion
Excel 365 Autofill
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.
- Thanks, sorted
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!
