Many thanks for all your help and efforts. After I initially struggled to find a full-time flying job, I got settled into the. You can also download the excel file from here: Excel Pilot Logbook® began as a fairly rudimentary spreadsheet with a single sheet for logbook entries something simple enough to SUM hours while I was a student pilot working towards my Private Pilots Licence. My problem to solve WITHOUT using vba: calculate until when I am current on the aircraft type and day/night as shown in the screenshot (the two bottom parts) As you will see I have different flights with different amount of landings per flight.

Please have a look at following screenshot (download link see below), which is a cut down version of my big excel logbook. To make things even more complicated, there are different currencies, which means I need to keep track of staying aircaft type current (C150, C152, and C172) as well as DAY and NIGHT current. (or officially spoken a pilot keeps current whenever (s)he is doing 3 takeoffs and landings within the 90 days, but I focus on landings only as I always do the takeoffs). So the rule here and pretty much around the world is that your currency counts from your Now I'd like to add a 'currency-calculator', which should show me until when I am type and day/night current based on my landings. I recently got my pilots license and started using Microsoft Excel as my backup logbook.