Create Automatic Date Sequences in Excel (The Smart Way) Need a long list of dates in Excel? Typing them one by one or dragging the fill handle is slow, error-prone, and outdated. Modern Excel offers a much faster and cleaner solution. A single formula that can generate an entire date range instantly and that is the SEQUENCE function, available in Excel 2021 and newer. To create a full year of dates starting from January 1, 2026, use this formula: =SEQUENCE(365,1,DATE(2026,1,1),1) This formula c