Forecasting By Date

  • Thread starter Thread starter dzeitler
  • Start date Start date
D

dzeitler

I track inspections that are required to be done to aircraft. diffferen
inspections have to be done at certain dates. I track these on
spreadsheet. I have a column of dates about a mile long. Im trying t
get excel to show me only the inspections that are coming up in th
next 3 months(90 days) and filter out the rest. I am trying to do thi
so I can record a macro to do this task at a click of a button. I woul
greatly appreciate any help...
 
Here are two options:

A2: Inspection date

Put this in a new column:
=DATEDIF(A2,TODAY(),"D")
...or this:
=IF(DATEDIF(A2,TODAY(),"D")<90,"Insp. in 90days","")

Then use Autofilter to filter all dates that are Less then 90
The second option could, also be used together with a PivotTable

Hope this helped
Ola Sandström
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Monthly Inspection Database 0
Nested counting query 0
cell color in conjunction with upcoming date 2
Add # of months and get result last day of # months. 2
Limit data in field to within 90 days of another field... 4
See ALL Modified Dates (not just Last Modified)? 1
Generating a date into the future 5
Excel Forecasting Dates Out to the Day 3

Back
Top