Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Displaying rolling data for a set time period
Good Afternoon All!
Basic problem, but for some reason none of the things I have tried have worked. I have created a logbook in excel for myself as a back up to my pilots logbook. I have it seperating all the data in terms of aircraft type, aircraft ID, type of flying etc., but what I need is for excel to filter the past 30 days and 90 days worth of flying, which must be on a rotating basis (so as we go forward one day, the formula will automatically). The columns that I have are the Date, Aircraft Type and Rego, Pilot and Co pilot, and then 16 columns displaying different types of flying (day, night, single engine, multi engine), and I have 3 sheets to seperate and display the data. Please Help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Displaying rolling data for a set time period
for 30 days:
your_date =TODAY()-30 90 days: Your_date =TODAY()-90 HTH "JMK" wrote: Good Afternoon All! Basic problem, but for some reason none of the things I have tried have worked. I have created a logbook in excel for myself as a back up to my pilots logbook. I have it seperating all the data in terms of aircraft type, aircraft ID, type of flying etc., but what I need is for excel to filter the past 30 days and 90 days worth of flying, which must be on a rotating basis (so as we go forward one day, the formula will automatically). The columns that I have are the Date, Aircraft Type and Rego, Pilot and Co pilot, and then 16 columns displaying different types of flying (day, night, single engine, multi engine), and I have 3 sheets to seperate and display the data. Please Help! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Displaying rolling data for a set time period
So knowing that this is how you get it to display the previous date 30 days
ago, how then do I add the data in the adjoining cells? Perhaps I need to reword what I want done. :( What I need is for it to say "OK, this is the date 30/90 days ago, now based on that how many hours have been flown between this date and todays date"? I was thinking of some sort of formula like a sumif("x:x", today()-30, "x:x)) or something like that, but this does not work. "Toppers" wrote: for 30 days: your_date =TODAY()-30 90 days: Your_date =TODAY()-90 HTH "JMK" wrote: Good Afternoon All! Basic problem, but for some reason none of the things I have tried have worked. I have created a logbook in excel for myself as a back up to my pilots logbook. I have it seperating all the data in terms of aircraft type, aircraft ID, type of flying etc., but what I need is for excel to filter the past 30 days and 90 days worth of flying, which must be on a rotating basis (so as we go forward one day, the formula will automatically). The columns that I have are the Date, Aircraft Type and Rego, Pilot and Co pilot, and then 16 columns displaying different types of flying (day, night, single engine, multi engine), and I have 3 sheets to seperate and display the data. Please Help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
average rate of change per given time period between 2 moments in time of a value | Excel Worksheet Functions | |||
Formula for calculating 12 month rolling period | Excel Discussion (Misc queries) | |||
Every time i put a number with period it becomes a date and time | Excel Discussion (Misc queries) | |||
rolling time period | Excel Worksheet Functions | |||
Rolling period | Excel Discussion (Misc queries) |