Active excel

[humaila]

Hi guys and girls and please help.
I am trying to make an "active excel sheet".
To be specific, imagine there is a boat travelling by a schedule and I want to show in a cell the actual port/status, next port/status name, time until next location, time until arrival/departure.
I have the schedule, but don't know where/how to start.
The reference point is now(date&time).
The schedule is like this, 1st 10 days of July. The fact is that if I reffer to DAY, I have missing days, like 07/02/2019, when the boat sails all 2nd of July. Same story with 4th, 10th etc.
Thanks and sorry if there is something simillar but had no idea what to search for.
Regards!

[TABLE="width: 364"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]ARRIVAL[/TD]
[TD]Location[/TD]
[TD]DEPARTURE[/TD]
[/TR]
[TR]
[TD]07/01/2019 7:00:00[/TD]
[TD]Bruges[/TD]
[TD]07/01/2019 14:59:59[/TD]
[/TR]
[TR]
[TD]07/01/2019 15:00:00[/TD]
[TD]At Sea[/TD]
[TD]07/03/2019 6:59:59[/TD]
[/TR]
[TR]
[TD]07/03/2019 7:00:00[/TD]
[TD]Copenhagen[/TD]
[TD]07/03/2019 16:59:59[/TD]
[/TR]
[TR]
[TD]07/03/2019 17:00:00[/TD]
[TD]At Sea[/TD]
[TD]07/05/2019 8:59:59[/TD]
[/TR]
[TR]
[TD]07/05/2019 9:00:00[/TD]
[TD]Stockholm[/TD]
[TD]07/05/2019 18:59:59[/TD]
[/TR]
[TR]
[TD]07/05/2019 19:00:00[/TD]
[TD]At Sea[/TD]
[TD]07/06/2019 6:59:59[/TD]
[/TR]
[TR]
[TD]07/06/2019 7:00:00[/TD]
[TD]Visby[/TD]
[TD]07/06/2019 16:59:59[/TD]
[/TR]
[TR]
[TD]07/06/2019 17:00:00[/TD]
[TD]At Sea[/TD]
[TD]07/07/2019 8:59:59[/TD]
[/TR]
[TR]
[TD]07/07/2019 9:00:00[/TD]
[TD]Tallinn[/TD]
[TD]07/07/2019 17:59:59[/TD]
[/TR]
[TR]
[TD]07/07/2019 18:00:00[/TD]
[TD]At Sea[/TD]
[TD]07/08/2019 6:59:59[/TD]
[/TR]
[TR]
[TD]07/08/2019 7:00:00[/TD]
[TD]St Petersburg[/TD]
[TD]07/09/2019 17:59:59[/TD]
[/TR]
[TR]
[TD]07/09/2019 18:00:00[/TD]
[TD]At Sea[/TD]
[TD]07/11/2019 8:59:59[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

This should get you started

Book1
	A	B	C	D	E	F
1	ARRIVAL	Location	DEPARTURE
2	07/01/2019 07:00	Bruges	07/01/2019 14:59		Current	At Sea
3	07/01/2019 15:00	At Sea	07/03/2019 06:59		Next	Stockholm
4	03/07/2019 07:00	Copenhagen	03/07/2019 16:59		Due	05/07/2019 09:00
5	03/07/2019 17:00	At Sea	05/07/2019 08:59
6	05/07/2019 09:00	Stockholm	05/07/2019 18:59
7	07/05/2019 19:00	At Sea	07/06/2019 06:59
8	07/06/2019 07:00	Visby	07/06/2019 16:59
9	07/06/2019 17:00	At Sea	07/07/2019 08:59
10	07/07/2019 09:00	Tallinn	07/07/2019 17:59
11	07/07/2019 18:00	At Sea	07/08/2019 06:59
12	07/08/2019 07:00	St Petersburg	07/09/2019 17:59
13	07/09/2019 18:00	At Sea	07/11/2019 08:59
Summary

Cell Formulas
Range	Formula
F2	{=INDEX($B$2:$B$13,MATCH(1,($A$2:$A$13<=NOW())*($C$2:$C$13>=NOW()),0))}
F3	{=INDEX($B$2:$B$13,MATCH(1,($A$2:$A$13<=NOW())*($C$2:$C$13>=NOW()),0)+1)}
F4	{=INDEX($A$2:$A$13,MATCH(1,($A$2:$A$13<=NOW())*($C$2:$C$13>=NOW()),0)+1)}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[humaila]

OMG, Thank you so so so much!!!

 

[Fluff]

You're welcome & thanks for the feedback