D

#### Diver Dan

cell with the range of dates. The dates are all entered from another

sheet by a user and this page is a summary page the formula looks

something like:

=A25&"-"&IF(AND(A26=0,A27=0,A28=0,A29=0,A30=0,A31=0,A32=0,A33=0,A34=0,A3

5=0,A36=0,A37=0),A25,IF(AND(A27=0,A28=0,A29=0,A30=0,A31=0,A32=0,A33=0,A3

4=0,A35=0,A36=0,A37=0),A26,IF(AND(A28=0,A29=0,A30=0,A31=0,A32=0,A33=0,A3

4=0,A35=0,A36=0,A37=0),A27

with A25 being the first date and the sequence of IF statements

determining what the end date should be. This works fine untill the 7th

If statement, because I guess that is the maximum nested ifs one can

have. It seems using an array will help with this but I am lost. Any

help is appreciated.

--