Hi All
I am looking for a formula that will calculate the Actual Arrival Date in column in D of the examples below. I have been searching this forum for quite a while now and have tried many different if statements of my own without success. Columns A – C are imported in from an Access table over which I have no control. Row 1 is relatively simple but the actual arrival date for row 2 would be one day less than the booked arrival date whilst the actual arrival date for row 3 would be one day greater than the booked arrival date and I am struggling to get these to work.
Any help would be much appreciated.
A B C D
Booked Arrival Date Booked Arrival Time Actual Arrival Time Actual Arrival Date
01/06/11 21:00 23:00
02/06/11 00:40 23:30
01/06/11 22:20 00:50
I am looking for a formula that will calculate the Actual Arrival Date in column in D of the examples below. I have been searching this forum for quite a while now and have tried many different if statements of my own without success. Columns A – C are imported in from an Access table over which I have no control. Row 1 is relatively simple but the actual arrival date for row 2 would be one day less than the booked arrival date whilst the actual arrival date for row 3 would be one day greater than the booked arrival date and I am struggling to get these to work.
Any help would be much appreciated.
A B C D
Booked Arrival Date Booked Arrival Time Actual Arrival Time Actual Arrival Date
01/06/11 21:00 23:00
02/06/11 00:40 23:30
01/06/11 22:20 00:50