Skip to content

Excel Tutorial

List All Dates Between Two Dates in Excel | One VBA Macro Method and Two Formula Methods

    So you want Excel to generate a list of all dates between two dates.  This video demonstrates three ways you can achieve this. Click here to download the featured file (including code) Method 1: Using the SEQUENCE Function Click here to see this part of the video Here’s the formula used in the video: =C2+SEQUENCE(C3-C2+1,,0)… Read More »List All Dates Between Two Dates in Excel | One VBA Macro Method and Two Formula Methods