Show a list of dates from given date

[jm23bg]

Resolved, thanks guys.
Hi all
I wondered if you would be so kind.
I have a list of various dates in column C in date order.
How would I show the list starting in B1 that is after the date entered in A1
Regards
John

[:) Sixthsense :)]

In B1 Cell

=IFERROR(SMALL(C:C,COUNTIF(C:C,"<="&A1)),"")

[jm23bg]

Hi
Many thanks, but that does not work for me.
Please see attached sheet.
I am looking for the full list after the date in A1 shown in B1 and below.
Hope this helps.
Regards
John

[rahi_feri]

Hi
Maybe you can use this

[azumi]

I see the file and need for clarify, what the logic? and the results?

[jm23bg]

Many thanks again, but that is showing dates A1 and before, while I am looking for dates A1 and after.
Regards
John

[jm23bg]

Hope the last post helps AZUMI

[jm23bg]

Rahi's file has disappeared.

[azumi]

If you looking for earliest and latest date, just use

=MIN(C2:C15)

=MAX(C2:C15)

if not tell me the expected result

[jm23bg]

Hi
Thanks, but I would like to the view in B the full list that is later than the date that will be entered in A1.
Regards
John

[azumi]

I think I have the idea what exactly what you after, pls see the file attach,
using array formula (means when ENTERING the formula you must press CTRL+SHIFT+ENTER button all together,
not ENTER alone, and then you can copied down as necessary).

[jm23bg]

Hi
Nearly there
As A1 date is in the list C, I would like to include that as the first date in B
TIA
John

[newdoverman]

This will copy the date in A1 and all the dates in column C that follow that date. Enter in B1 and fill down:

Please Login or Register  to view this content.

If you want column B to start with the date after the date in A1. Enter the following in B1 and fill down:

Please Login or Register  to view this content.

[jm23bg]

Hello Newdoverman
Your first option works well, however if the date in A1 is not an actual date in Col C and it may not necessarily be, it results in error, can this possibly be rectified?

Regards
John

[newdoverman]

Please Login or Register  to view this content.

[azumi]

Done and fix it and hope works

[newdoverman]

A slightly different formula that will return values Greater Than or Equal to A1.

Enter with Ctrl + Shift + Enter

Please Login or Register  to view this content.

	A	B	C
1	06/03/2014	06/03/2014
2		06/03/2014	01/03/2014
3		07/03/2014	02/03/2014
4		08/03/2014	03/03/2014
5		08/03/2014	04/03/2014
6		08/03/2014	06/03/2014
7		15/03/2015	06/03/2014
8		17/03/2014	07/03/2014
9		23/03/2014	08/03/2014
10		28/03/2014	08/03/2014
11			08/03/2014
12			15/03/2015
13			17/03/2014
14			23/03/2014
15			28/03/2014

[jm23bg]

Hi
Very many thanks to all, sorted.
Regards
John

[:) Sixthsense :)]

	B
2	=IFERROR(SMALL(C:C,COUNTIF(C:C,"<="&MAX($A$1,AGGREGATE(4,6,$B$1:B1)))+IF(ROWS($1:1)-1,1,0)),"")

Drag the above formula down...

	A	B	C
1	6-Mar-14
2		6-Mar-14	1-Mar-14
3		7-Mar-14	2-Mar-14
4		8-Mar-14	3-Mar-14
5		17-Mar-14	4-Mar-14
6		23-Mar-14	6-Mar-14
7		15-Mar-15	6-Mar-14
8		28-Mar-20	7-Mar-14
9			8-Mar-14
10			8-Mar-14
11			8-Mar-14
12			15-Mar-15
13			17-Mar-14
14			23-Mar-14
15			28-Mar-20
16
17
18
19
20
21