Can I group overdue Invoices by date from an Excel worksheet?
 

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.

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.