Count days between aircraft type landings

[Rich Ard]

Hello,

I'm an analyst for and airport. I would like to count number of days between the landings of different aircraft types (cargo aircraft or freighters). The data does not come in clean.

My first column is dates. The following columns are aircraft types, but each day the same aircraft don't necessarily land each day.

e.g.

1/1/16, AN225, AN124, B747-F, B777F
1/2/16, B747-COMBI, B777F, AN124, B737-COMBI
1/3/16, B747F, AN225, B737F, A320F

Et cetera

I have several years of data. Data is daily aircraft landings.

Hacked at the forum first for something similar but I don't think I know how to search. Tried searching for DATEIF and count days between dates but couldn't find a solution.

Thank you in advance for any help you can offer.
Rich Ard from Texas

 

[Rick Rothstein]

First off, I was not upset... I was just trying to remind you of the problems we face in trying to answer questions posed here. You are not the first and, unfortunately, will not be the last to supply insufficient information for the question being asked. That is only one of the "mistakes" people asking questions here make... the other is simplifying their data layout so that we produce code or formulas for a question the questioner does not really have and rarely are they able to take the answer for the simplified data and extend it to the real problem they have. This almost always involves them coming back to us and, after a few back-and-forth postings, showing the real data layout which, if they would have done so originally, would have led to them getting an answer much quicker. Anyway...

Okay, the information you posted in Message #10 was a great start, but you still need to explain how you are counting your days. For the life of me I cannot figure out how you got the numbers you show in Message #6 from the raw data you posted in Message #3. Take Equipment Code 74M... without some explanation of what you did to get the numbers for it, the numbers you posted do not look like they even come close to the output one would expect given your question. Can you clarify that for us?

 

[hiker95]

And a big thank you to hicker95 for your consideration in trying to find a solution.

Rich Ard,

You are welcome.

Sorry that I was not able to solve your request.

And, come back anytime.