Totally Lost - Dates in huge table, Range finder

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 :D

thanks

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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 :D
>
> thanks
>
>
> --
> kempy1000
> ------------------------------------------------------------------------
> kempy1000's Profile: http://www.excelforum.com/member.php...o&userid=37549
> View this thread: http://www.excelforum.com/showthread...hreadid=571812
>

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?

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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?
>
>
> --
> kempy1000
> ------------------------------------------------------------------------
> kempy1000's Profile: http://www.excelforum.com/member.php...o&userid=37549
> View this thread: http://www.excelforum.com/showthread...hreadid=571812
>

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