Min Max What's Wrong?
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
|