Finding last record in month for each of several types of record.

I have a database consisting of several types of record, (each
identified with a unique code), and each record has a date field.

The database has a varying number of records in each month, i.e not
necessarily one for each day.

I need to be able to identify the last record of each month for each
type of record, and sum the various value fields of each record type
across a range of months.

Can anyone suggest an Excel formula, which could be put outside the
database in a summary table, which could achieve this?

Usual TIA

Rgds


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
.