Minimum Date Greater Than Observation Start Date

[Guest]

I am trying to find the difference between dates. When I enter an observation
date my worksheet calculates the number of days for uptime based on the
observation period minus the number of days down. However, the problem is
when I look at an observation range where there is no data for the equipment.
what I Want to do is subtract off the difference between the observation
start date and the first date greater than that date for data, i.e.

Start date 7/1/06

Date with data
7/18/06
7/19/06
8/31/06
etc.
This would be 17 days taken off the number of active days for his piece of
equipment. I am trying to use a min() greater than the observation date, but
this is not working.

 

[Guest]

try
=min(if(date_range>start_date,date_range-start_date))
entered as an array control-shift-enter

 

[Guest]

Thanks a lot worked perfectly.

try
=min(if(date_range>start_date,date_range-start_date))
entered as an array control-shift-enter