How to extract & list all dates between two dates in Excel

Download PC Repair Tool to quickly find & set Windows errors automatically

Imagine a situation in which you need to create a appointment-wise table. For example, you are creating a schedule where you lot need to mention a date-wise listing of activities. In such a case, you would need a list of dates. Apparently, no list is unlimited, so your listing would take a starting and catastrophe date.

List all dates between two dates in Excel

For such cases, you could use the method explained in this article to obtain the list of dates between ii dates every bit a list in a column. Y'all have two ways of proceeding:

Create a list of sequential dates in Excel using the Fill up handle
Obtain a list of all dates betwixt two given dates in Excel using formula.

1] Create a listing of sequential dates in Excel using the Fill handle

Microsoft Excel has a Fill handle, which makes it like shooting fish in a barrel to create a list of sequential dates. While it doesn't exactly assistance with dates between two given dates, using this option is much easier than using the formula.

Simply Enter the date in say cell A1 and click anywhere outside the cell. And then click on the prison cell once again to activate the Fill up handle.

Pull the Fill handle down to create a list of sequential dates in Excel.

Obtain a list of all dates between ii given dates in Excel using formula

The formula to obtain a list of all dates between two given dates in Excel is a little complicated. Nosotros volition explain information technology using an example:

Let united states of america suppose the starting date is mentioned in cell A1, and the ending date is mentioned in cell A2. You need to obtain the listing in cavalcade C. The procedure for finding the list of dates would be equally follows:

Offset, enter the formula and press Enter:

=A1+i in cell C1

It volition display the date next to the starting date in cell C1.

Now, type the following date in cell C2:

=IF($A$1+ROW(A1)>=$A$2-1,"",C1+1)

Click anywhere outside prison cell C2 and then back on C2 to highlight the choice to pull the formula down. Pull the formula downwards till you beginning getting bare results on the cells. Hit Enter to display the results.

The problem with this formula is that it would exist hard to define the syntax or alter it. Furthermore, the dates aren't exactly in order. The first and last dates remain in cells A1 and A2. The dates in cavalcade C are the ones betwixt these dates.

The resolution to this problem could involve a bit of dragging, cutting, and pasting.

Promise this helps.

Karan Khanna is a passionate Windows user who loves troubleshooting Windows xi/10 bug in specific and writing almost Microsoft technologies in general.