I've got a pretty tough question, at least I think it is. As part of a flight log I'm spreadsheet I'm putting together for a pilot, I need a way to automatically delete a portion of data based on the date from a spreadsheet he gets each month from the airline. I was hoping to incorporate some sort of "if, then" statement into a macro that will run each time he opens the new spreadsheet each month. What happens is occasionally a trip will carry over from the end of a month to the beginning of the next and this throws off the overall numbers on the spreadsheet I'm making by essentially doubling up the flight time on those few days. I'll attach a pdf of one such month so you can see what I mean. Any ideas would be great, and please let me know if I can clarify anything, thanks!

Flight log example.pdf