Alan, thank you for your help (I've never programmed in Excel before).
I ended up creating a third column using an If-Then and assigning a '1
to any date that had a non-zero value, else '0'. Then, in a fourt
column, I multiplied the original date by the third column. Using MAX
I was able to get the most recent date. And =Days360(value, Today()
gave me the number of days that have passed from the last NVG fligh
until today. I probably wouldn't have figured it out without you
suggestions. Thanks again. :

--
bobsmith58
-----------------------------------------------------------------------
bobsmith58d's Profile: http://www.excelforum.com/member.php...fo&userid=1452
View this thread: http://www.excelforum.com/showthread.php?threadid=26147