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