Date Interval Predictions

M

michaeloj.simpkins

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.
 
G

Guest

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

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

Top