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