landing

Hello! Here attached is my table. This is a table that get updated every day. Every time the pilot or copilot make a landing, it is recorded. For accuracy, pilots need to complete 3 landings every 90 days. I am trying to find a formula that will give me the date of the last 3rd landing...

I have an issue of how to count military time with the wrap around the "Zero" hour. Also there is no defined length of how many blocks there are. 1 KDFW 1505 KNBG 1630 KSVN 1945 KMIA 2200 7HRS 5MIN 2 KMIA 2000 KDFW 2300 KLSV 0030 KOKC...

Hi Everyone, So attached is a sample logbook. In the Dashboard TAB I need to know what date my 3rd to last landing was on each type of aircraft. In Cell 'AG5:AH17 it needs to display the date plus 90 days. So for example 8 nov 17 was my 3rd to last landing in a DA42 at night. So i would become...

I was wondering if it's possible to send a number from one cell to be added in another. The Sum function receives numbers from different cells but I want to send it. I have one sheet that is a template for the input information that will be copied daily (ie Game 1, 2, 3 Etc.) and another sheet...

So, I'm trying to get the latest information based on dates for flying. <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 113px"><col width="147"><col width="170"><col width="100"><col width="152"><col...