I’m working on a pilot flight logbook; all is going well except for a couple things. Two features I want to add has me stumped.

1. I have 2 columns, column A5 thru A10000 has the date that I flew, column C5 thru C10000 has the number of hours I flew. I need a formula the will calculate the number of hours flown in any given 365, 182, 90, 60 and 30 day period.

2. When printing I want to be able simply hit the print button and have it print only the rows that have actually have data. In other words if there are 100 entries, say A1 thru A100, it will automatically set the print area to print only A1 thru A100.

Hope you guys can help.

Back to top