Hello all, I’m in need of some excel formula help. In my free time (yeah right…) I like to fly and I’ve made a log book using excel to help me keep track of my flight time. Currently it’s on two sheets, one for the actual flight information entry and the second is a totals sheet. On the totals sheet I’d like to keep track of yearly requirements which is based on my birth month.
So, here is what I want to do look at the Date column on ‘Log Book’ (!A:A) and if it is between 2011,6,1 and 2012,5,31 I want it to go to the total flight time column (!Q:Q) and display the running total on ‘Totals’ sheet. Can someone help me out? Thanks!
