![]() 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |