My end date is not always on the same row as my beginning date, and I need to be able to calclate the number of days between the beginning date and end date. This would work beautifully if there was only one trip per sheet, but there's not. Can someone help me with a formula to find the next date in the end date column?

In this example, there are 2 trips. The first trip spans 3 days and the second spans 2 days. I need to automatically calculate the "Days", but the number of rows for each trip can vary.

Trip Beginning Date End Date Days

NY to DC 3/1/2011

DC to Dallas

Dallas to OKC

OKC to NY 3/4/2011 3

NY to Miami 3/5/2011

Miami to LA

LA to Chicago 3/7/2011 2