have a range of dates in a column
i can match an input date with this code
where the input date is in cell H20 (eg 04/04/2008)
the problem is that not all the dates in the range are consecutive and there may be the same date more than once eg
the problem is if the date in cell H20 (inputted by user) does not exist in column D, it all goes wrong.
what i would like to achieve is a way of incrementing the cell date by one day until it matches a date in the range, in this case if 02/04/2008 was entered 03/04/2008 would be picked up.
any help and explaination to an answer greatly appreciated