Need to output a list of dates in a certain timeframe

[TPDave]

Hi All,

In sheet 2 of my workbook I have a series of dates and in sheet one I have a start date and an end date in cells B1 and B1 respectively. What I'm looking for is a list of dates (from A5 down on sheet 1) that fall between the two specified in the start and end date cells. I assume I'm looking for an array formula but don't know! Hastily made example workbook attached.

Any help would be greatly appreciated. Thanks

[Melvinrobb]

1. retype your dates in b1 and b2 so they are recognized as dates.
2. Change cell A5 to =b1
3. Change cell A6 to =IF(OR(A5=$B$2,A5=""),"",A5+1) and drag down.

[TPDave]

Hi Melvinrobb,

That just gives me a sequential list of dates between the two specified dates, I need it to list the applicable dates from the list given on the second sheet. Thanks

[Melvinrobb]

This Array formula in A5:

Please Login or Register  to view this content.

This array formula in A6 and down:

Please Login or Register  to view this content.

There is probably a cleaner way, with only one formula, but... this will work.

[TPDave]

And work it does, many thanks!