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

  In this video tutorial I look at quick ways of creating a list of dates. How to Create a List of Concurrent Dates Click here to view this part of the video To create a list of concurrent dates, follow these steps: Enter your starting date in a cell Select that cell (if not… Read More »AutoFill Dates in Excel – Days, Weekdays, Months & Years

  In this video, I demonstrate how to use dates within an IF formula. I want to be able to compare two dates to find if one date is before or after another date. I also want to be able to calculate whether a date is after or before today’s date. You can compare two… Read More »Excel – IF Date is Before or After Another Date | IF Date is Before or After Today