Column D contains the dates, as before.
Cell A1 only is to show the next date after today's date.

Try in A1, array-enter the formula by pressing Ctrl+Shift+Enter:
=MIN(IF(D$2:D$100TODAY(),D$2:D$100))
Format A1 as date. Adjust the range to suit.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Ellie" wrote:
Sorry Max, having just been advised the structure of the spreadsheet has
changed and in turn also the date basis of my earlier request, starting again:

Column D contains the dates, as before. Cell A1 only is to show the next
date after today's date.

Sorry for the change and hope you are able to help.

Ellie