I run into spreadsheets that look like the attached frequently. I am looking for a solution that will provide me with the Arrival date and Departure date without wanting to cry.

The user adds the information by placing a 1 or an x sometimes in the column under the date a guest is staying.

The first column with a value is their arrival date.
The first column with no value is their departure date.

In the case of a value in column C, the departure date would be the following date 4/28.

So for row 2 of the attached, Arrival date is 4/25 and departure date is 4/28.
Row 7 would be Arrival 4/25 and departure 4/26.

Is there a way to make this happen? It can be with formulas or macros or whatever. This is just so time consuming.

Arrival Departure date Example workbook.xlsx