Totally Lost - Dates in huge table, Range finder

[kempy1000]

Hi all
I have a masive table of dates (the date is created via a if formula)
what i need is so wheni enter 2 dates in 2 cells the system checks all
the dates between the two specified and then returns the contents of
them to a small area on the page.

eg.


Dates To Test 14/08/2026 19/08/2026



Results

14/08/2026

15/08/2026

16/08/2026

17/08/2026

18/08/2026

19/08/2026




Table

14/08/2026
14/08/2026
14/08/2026
14/08/2026
14/08/2026
14/08/2026
14/08/2026
14/08/2026
14/08/2026

15/08/2026
15/08/2026
15/08/2026
15/08/2026
15/08/2026
15/08/2026
15/08/2026
15/08/2026
15/08/2026

16/08/2026
16/08/2026
16/08/2026
16/08/2026
16/08/2026
16/08/2026
16/08/2026
16/08/2026
16/08/2026

17/08/2026
17/08/2026
17/08/2026
17/08/2026
17/08/2026
17/08/2026
17/08/2026
17/08/2026
17/08/2026

18/08/2026
18/08/2026
18/08/2026
18/08/2026
TAKEN
18/08/2026
18/08/2026
18/08/2026
18/08/2026

19/08/2026
19/08/2026
19/08/2026
19/08/2026
19/08/2026
19/08/2026
19/08/2026
19/08/2026
19/08/2026

20/08/2026
20/08/2026
20/08/2026
20/08/2026
20/08/2026
20/08/2026
20/08/2026
20/08/2026
20/08/2026

21/08/2026
21/08/2026
21/08/2026
21/08/2026
21/08/2026
21/08/2026
21/08/2026
21/08/2026
21/08/2026

22/08/2026
22/08/2026
22/08/2026
22/08/2026
22/08/2026
22/08/2026
22/08/2026
22/08/2026
22/08/2026

23/08/2026
23/08/2026
23/08/2026
23/08/2026
23/08/2026
23/08/2026
23/08/2026
23/08/2026
23/08/2026

24/08/2026
24/08/2026
24/08/2026
24/08/2026
24/08/2026
24/08/2026
24/08/2026
24/08/2026
24/08/2026




i dont mind using script or anything like that, i dont have much
knowlage of it but do have coniderable understanding of other langages
and usually figure it out

thanks

 

[Bernie Deitrick]

Use Data / AutoFilter... and filter your date column based on two conditions:

Greater than or equal to.. First Date

And

Less than or equal to.... Second Date

HTH,
Bernie
MS Excel MVP

 

[kempy1000]

Thank you very much but is there a way so that the auto filter can
filter using a cell value rather than having to write it in?

 

[Bernie Deitrick]

No. You would need to use a macro, like

Sub Example()

Range("C6:F1000").AutoFilter Field:=2, Criteria1:=">=" & Range("D2").Value, Operator:=xlAnd, _
Criteria2:="<=" & Range("D3").Value

End Sub

D2 and D3 held the values on which you wanted to autofilter column D (the second column of the
range)

HTH,
Bernie
MS Excel MVP

 

[kempy1000]

Hi thanks for that its ok but reverses the last date so when i try to
choose the outer boundry as 01/12/2006 it uses 12/01/2006 and also it
hides the chosen values where i need it to show the chosen dates and
hide the rest