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.