Hi,

Ive recently been given a new task at work to create a report of all overdue
invoices on excel 2007. Each record has basically a due date, and the amount
of the invoice, so i've used the formula (for example):

=SUMIF(A2:A30, "<=19/10/2007", B2:B30)

to sum the value of each invoice that is overdue (i.e has a due date less
than today). The first problem is that the "TODAY()" tool doesn't work in the
formula, nor does "NOW()", so i manually have to enter the days date in the
formula.

The second problem is how to extract the value this formula produces, and
how to put it into a new spreadsheet (i.e. the report im required to
produce), as there are many different spreadsheets this has to be done for.

Any help would be greatly appreciated and will save me a fair amount of time
each week!