Countdown to dates

[Drwats0n]

Hi Guys,

i have a range of dates(holidays/impt dates) as per below.
I want to have a countdown statement, something like,

"5 more days to Event 4"

I do know how to do that 1 statement countdown, but i dont know how to instruct excel to ignore those expired dates.
For example today's date is 30th November, i want excel to carry on to the next future event(9th Dec) based on this range of dates and ignore the expired dates.

Date	Day	Events
1 Jan 16	Fri	Event 1
7 Feb 16	Sun	Event 2
09 Dec 16	Fri	Event 3
12 Dec 16	Mon	Event 4

<tbody>
</tbody>

The reason for requesting this is because i dont want to refer to my calender whenever i am doing my planning at excel spreadsheet.
It can also constantly remind me of any impt upcoming dates as most of the time im looking at my main spreadsheet for planning purposes.

Thanks!

 

[Matt Rogers]

Hi.

Excel Workbook
	A	B	C	D	E
1	Date	Day	Events
2	01/01/2016	Fri	Event 1
3	02/07/2016	Sun	Event 2
4	12/09/2016	Fri	Event 3		9 more days to Event 3
5	12/12/2016	Mon	Event 4		12 more days to Event 4
Sheet