Hello

I have a ss contains process data with several columns of dates. As a
product goes through each process the date is captured. I now need to
analyse how long it took between each process step but the problem is
that not every product goes through all processes so I need to look at
the next non-blank one. I can do bits with nested IFs but there are
too many possibilities and the nesting is limited (plus I think there
must be a better way of doing it. I'd like to insert a column between
each date and have look at the data in the previous cell and calculate
the difference to the next non-blank date.

The data is structured -

Product Qty Date started Date1 Date2 Date3 Date4
---- Date29

ABC 5 15/10/07 16/10/07 17/10/07
18/10/07 22/10/07
XYX 4 16/10/07
19/10/07 20/10/07
ASD 20
20/10/07 20/10/07
21/10/07
LKJ 15 17/10/07
18/10/07 22/10/07