> 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.
0 kommentar(er)
