| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date format issue | New Users to Excel | |||
| Insert Automatic, Non-Updating Date Stamp | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Another Date issue. | Excel Worksheet Functions | |||
| Where is DateDiff function in Excel 2002 ? | Excel Worksheet Functions | |||
Hybrid Mode
