Thanks Max, I will give it a go

John

"Max" wrote:

Dates* are just numbers in Excel, so the latest date within a dates range
will be the highest number (ie maximum) within that range.
*real dates recognized by Excel, that is
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---