Dave and Nick
Nick you are right. I had cells in the range with formated for date and MIN
was picking that up. Nothing wrong after all.

I apologize for my oversight, but appreciate your responses and help.

"Dave F" wrote:

How is the data formatted in the range A4:A36?

Dave
--
Brevity is the soul of wit.


"shep" wrote:

XP Pro Office 2003
I have this in cell A2:
="For "&TEXT(MIN(A4:A36),"dd-mmm-yy")&" through
"&TEXT(MAX(A4:A36),"dd-mmm-yy")

I enter today's date in cell A4 and get this returned in cell A2
For 00-Jan-00 through 04-Oct-06

Why am I not getting correct date for MIN?

Thanks