View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Billigmeier David Billigmeier is offline
external usenet poster
 
Posts: 176
Default Can I group overdue Invoices by date from an Excel worksheet?

Try creating a helper column that outputs a 1 if they are overdue and 0 if
not, something like the following. I used a reference date of August 1,
2006... change to fit your overdue date:

=IF(A1DATE(2006,8,1),1,0)

Then, use auto-filter (<Data<Filter<Auto-Filter), and choose to only
display rows that have a "1" for this newly created column.

--
Regards,
Dave


"Newbie" wrote:

I get an Excel worksheet sent every week with all the Outstanding Invoices.
I have to phone customers about the overdue ones.
Is there any way of collecting the ones over a certain date to make my life
easier?
I could have 6 months worth of Invoices but only need to chase 3 months worth.