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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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(A1>DATE(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.
 
Back
Top