Charting a flight logbok
 

Hi,
I have simple flight logbook where every flight is written with the date
in column A and flight times from column J and outwards.

There are several flights per day and therefore several equal dates in
column A. I do not sort A, I just write flights in the order they
happen.

I'm trying to make one chart that shows total flight time last 30 days
always counting backwards from last entry.

And one chart showing total flight time last 365 days with one column
for each month and one column for the total of the last 365 days.

I can make this manually but I would like to make this dynamically.

Thanks,
Paul