TangoGolf_Niner
New Member
- Joined
- Mar 5, 2021
- Messages
- 2
- Office Version
- 2016
- Platform
- Windows
Hi everybody,
I'm working for an airline back office and I try to set up an overview for upcoming dates of our flights.
I have a sheet where a lots of data is listed (Date, FltNo, airports of departure and destination etc etc).
What I am trying to do is the following:
I need a formular that gives me the next upcoming date of flight linked to a certain destination.
If in the column F (Destinations) there is an entry e.g. AMS (Amsterdam) and the date is today or later (column C), if true, give me the MIN (nearest date) as of today.
Unfortunately I can't see where I am hitting a wall right now...
I built this so far: =MIN(IF(('Input_Flight-Plan'!$F$2:$F$16015='Schedule-Analyse'!$A16)*('Input_Flight-Plan'!$C$2:$C$16015>=TODAY());'Input_Flight-Plan'!$C$2:$C$16015;"")), but I get only today's date as a result.
Thanks in advance, sitting for hours already and can't figure it out.
All the best,
T
I'm working for an airline back office and I try to set up an overview for upcoming dates of our flights.
I have a sheet where a lots of data is listed (Date, FltNo, airports of departure and destination etc etc).
What I am trying to do is the following:
I need a formular that gives me the next upcoming date of flight linked to a certain destination.
If in the column F (Destinations) there is an entry e.g. AMS (Amsterdam) and the date is today or later (column C), if true, give me the MIN (nearest date) as of today.
Unfortunately I can't see where I am hitting a wall right now...
I built this so far: =MIN(IF(('Input_Flight-Plan'!$F$2:$F$16015='Schedule-Analyse'!$A16)*('Input_Flight-Plan'!$C$2:$C$16015>=TODAY());'Input_Flight-Plan'!$C$2:$C$16015;"")), but I get only today's date as a result.
Thanks in advance, sitting for hours already and can't figure it out.
All the best,
T