Date Interval Predictions
 

I currently have a set of data (invoices) where one column contains the
expiry date of the invoice. I want to run a report which will bring up
all the invoices, whose expirations fall within the next 90 days of the
date that the report is run. This is easy to do in Access, but am
finding it impossible to do in Excel.

Date Interval Predictions
 

One way:
Use a helper column and enter:
=IF(C4<TODAY()+90,"Select","")
Then engage auto-filter on Helper-Column and pick Select.



" wrote:

I currently have a set of data (invoices) where one column contains the
expiry date of the invoice. I want to run a report which will bring up
all the invoices, whose expirations fall within the next 90 days of the
date that the report is run. This is easy to do in Access, but am
finding it impossible to do in Excel.