Hello!
For the past year or so I've been building up a logbook for flying which totals up all my different type of times (Just incase my logbook goes missing)
Lately i've been playing around with it and adding new features like how much time I have on each aircraft and various other things (on top of this, I have been making it user friendly so I could just hand it to people and it would just work for them and the only thing they'd need to ever do is add new row - This is an important aspect for my problem I present thee)
Now I would like Excel to tell me if I am current on an aircraft or not, or If I am Instrument Current (allows me to fly through clouds).
The instrument currency side is fairly easy as that is 3 approaches and 3 hours every 90 days (It is not Aircraft type dependent) and is the basis for working out if I'm current on aircraft type (i.e. it will be the same coding but with out the Aircraft type search)
The problem I'm having is with the currency on different types of aircraft.
I've tried using the SUMIF formula and it sort of works, and sort of doesn't.
=SUMIF('Pilots Log'!$A$11:$A$272,"******",'Pilots Log'!$AA$11:$AA$272)
Where A11-A272 is the date viewed as Month(mmmm) but has an actual Day() value. AA11 - AA272 is a column where I enter how many takeoffs I have done for each flight (eventually I will need to incorporate landings and having it search for aircraft type (as currency is associated with aircraft type) - bear this in mind as my approach may not work for including this)
Where the **** is where I am having the problem. Ideally I would like to have >=TODAY()-90 (I have to do 3 takes offs and 3 landings on aircraft type to remain current per 90 days). However it doesn't allow for this, so I tried placing =Today()-90 in a separate cell Call it X1, and then using >=X1 but it doesn't allow for this, how ever I COULD place >=40378 (Which is what X1 happens to equal today), or I could Place just X1 without the >= and it would give me the total takeoffs for that associated value.
So, my question is, how do I get around this? Originally I had a column which was =TODAY()-Date code for a particular Day and I could have the SUMIF formula running down that column instead of the Date Column and just say <=90 (less than because its Todays date - Date for a certain day), but I am wishing to make this user friendly and having this column does not allow for this as when you add a new row (for a new flight entry) you would then need to make allowances for this - I know I could use Macros but they don't always seem to play nicely when changing to a different OS like PC to MAC
Sorry for the Essay! I'm new to playing around in Excel so any help would be appreciated! If pictures, or a copy of the actual file is needed just let me know!
Thanks
For the past year or so I've been building up a logbook for flying which totals up all my different type of times (Just incase my logbook goes missing)
Lately i've been playing around with it and adding new features like how much time I have on each aircraft and various other things (on top of this, I have been making it user friendly so I could just hand it to people and it would just work for them and the only thing they'd need to ever do is add new row - This is an important aspect for my problem I present thee)
Now I would like Excel to tell me if I am current on an aircraft or not, or If I am Instrument Current (allows me to fly through clouds).
The instrument currency side is fairly easy as that is 3 approaches and 3 hours every 90 days (It is not Aircraft type dependent) and is the basis for working out if I'm current on aircraft type (i.e. it will be the same coding but with out the Aircraft type search)
The problem I'm having is with the currency on different types of aircraft.
I've tried using the SUMIF formula and it sort of works, and sort of doesn't.
=SUMIF('Pilots Log'!$A$11:$A$272,"******",'Pilots Log'!$AA$11:$AA$272)
Where A11-A272 is the date viewed as Month(mmmm) but has an actual Day() value. AA11 - AA272 is a column where I enter how many takeoffs I have done for each flight (eventually I will need to incorporate landings and having it search for aircraft type (as currency is associated with aircraft type) - bear this in mind as my approach may not work for including this)
Where the **** is where I am having the problem. Ideally I would like to have >=TODAY()-90 (I have to do 3 takes offs and 3 landings on aircraft type to remain current per 90 days). However it doesn't allow for this, so I tried placing =Today()-90 in a separate cell Call it X1, and then using >=X1 but it doesn't allow for this, how ever I COULD place >=40378 (Which is what X1 happens to equal today), or I could Place just X1 without the >= and it would give me the total takeoffs for that associated value.
So, my question is, how do I get around this? Originally I had a column which was =TODAY()-Date code for a particular Day and I could have the SUMIF formula running down that column instead of the Date Column and just say <=90 (less than because its Todays date - Date for a certain day), but I am wishing to make this user friendly and having this column does not allow for this as when you add a new row (for a new flight entry) you would then need to make allowances for this - I know I could use Macros but they don't always seem to play nicely when changing to a different OS like PC to MAC
Sorry for the Essay! I'm new to playing around in Excel so any help would be appreciated! If pictures, or a copy of the actual file is needed just let me know!
Thanks
Last edited: