We are a community for discussion among pilots, students, instructors and aviation professionals. I hope this makes sense and can get this sorted out.Welcome to /r/flying. At that point, I only need to do 3 approaches which brings me current until Nov. 3 on Apr 14, and 3 in May 17th), I am still only current until October 31st. Apr 14), then all expire in 6 calendar months (Oct 31st). I'm trying to create an equation that goes something like this, 'If the sum of columns R & S is at least 6 in the last 6 calendar months, AND the sum of column U is at least 1, then I am current for the next 6 calendar months.'Īdditional info: If all 6 approaches were done in one day (ex. Example: Received Jan 10th 2021, expires Jan 31st, 2022.īack to my problem. Regardless of what day of the month I get my medical check done, it will always expire on the last day of the month. An example of this is my 1st class medical. In aviation, we use calendar months for a lot of expiration dates. Columns 'R' and 'S' are the approaches, and column 'U' is the holds column. My requirements: In the previous 6 calendar months, I need to have done 6 approaches with at least 1 hold. I'm creating a 'currency sheet' in my workbook. They are identifiable with a special user flair.Ī community since MaAsking a question? Describe if you are using Excel (include version and operating system!), Google Sheets, or another spreadsheet application.Ībove is the link to a picture of my logbook. Occasionally Microsoft developers will post or comment. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors Date Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data.

NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified Only text posts are accepted you can have images in Text posts.Use the appropriate flair for non-questions.Post titles must be specific to your problem.

Excel pilot logbook redit