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