So in the example above, you would be current So if we are now at July 31, the preceding six calendar months would be Jan,įeb, Mar, Apr, May and Jun. A 'calendar month' is like the month of January, or February, etc.

They refer instead to the 'preceding six calendar I believe your interpretation of the regulations is incorrect. >current because I've only got 4 approaches within the past 180 days

>I'll be current for 180 days after Jan 1. >For example, I fly 2 approaches on Jan 1, 3 on Feb 10, and 1 on March > The values are entered in cells A50:A3000 and F50:F3000 > I think it's a simple formula if only I explained it clearly enough. > as soon as it finds at least 6 approaches, 2 on Mar 25th, + 2 on Mar > anymore because summing just 6 approaches from today's date would stop > Assuming I fly 2 more approaches on, say, March 25th, I'll be current > So I'm looking for a formula that will tell me I lose currency after > current because I've only got 4 approaches within the past 180 days > I'll be current for 180 days after Jan 1. > For example, I fly 2 approaches on Jan 1, 3 on Feb 10, and 1 on March > the last flight so I know when I lose my currency. > sum the approaches until it totals at least 6, and then add 180 days to > figure out a formula to look at column F from the most recent date and > number of instrument approaches flown on each flight. > Column A lists the date of each individual flight. > least 6 instrument approaches within the past 180 days to be current. > I'm a pilot and I keep my logbook in excel. The values are entered in cells A50:A3000 and F50:F3000 I think it's a simple formula if only I explained it clearly enough. The approaches on Jan 1st don't matter anymore because summing just 6 approaches from today's date would stop as soon as it finds at least 6 approaches, 2 on Mar 25th, + 2 on Mar 20th, + 3 on Feb 10th. So I'm looking for a formula that will tell me I lose currency after June 30th.Īssuming I fly 2 more approaches on, say, March 25th, I'll be current until Feb 10th + 180 days. After Jun 30, I won't be current because I've only got 4 approaches within the past 180 days (Feb 10th and March 20th). I'll be current for 180 days after Jan 1. I'm trying to figure out a formula to look at column F from the most recent date and sum the approaches until it totals at least 6, and then add 180 days to the last flight so I know when I lose my currency.įor example, I fly 2 approaches on Jan 1, 3 on Feb 10, and 1 on March 20. Column F is the number of instrument approaches flown on each flight. I am required to fly at least 6 instrument approaches within the past 180 days to be current.Ĭolumn A lists the date of each individual flight. I'm a pilot and I keep my logbook in excel.

Pilot logbook excel