Filtering by date

**b16dlg** · 05-20-2010, 05:58 AM

Good morning everyone

I have a sheet imported from SAP that has outstanding/open puchase orders by date. This sheet is generated by a manually run SAP ME2N report and i export the information into excel manually and the information is only dynamic in that it records SAP activity.

I have utilised the sort and filter operations to get the list in a certain order.

What I need to be able to do please, is filter the data so it only shows all purchase orders older than a certain date. This date could be 3 months 6 months 18 months etc etc need to be able to pick any date and only shiow orders older than this date really.

Not really sure how to set this up at all so any help would be appreciated, I have attached the spreadsheet but obviously blanked out certain values.

Thank you in advance

Damion

**Ryan Murtagh** · 05-20-2010, 06:13 AM

Good Morning,

If you are using Excel 2003, you should be able to use the (Custom...) option of Excel's AutoFilter to do what you need.

This link has more info on AutoFilter: http://www.ozgrid.com/Excel/AutoFilters.htm

**b16dlg** · 05-20-2010, 07:42 AM

Thank you

Feel like an idiot now lol just having one of those days where can't think straight. Simply forgot about the custom function.

Again Thank you