Min Max What's Wrong?

[Guest]

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

 

[Niek Otten]

I think you *do* get the right answer for MIN. One of your cells in A4:A36 is zero or something which is interpreted as zero by
the MIN function.
You can check by inserting a column in which you copy column A and format it as number.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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

 

[Guest]

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

Dave

 

[Niek Otten]

<in which you copy column A>

I mean with an =
--
Kind regards,

Niek Otten
Microsoft MVP - Excel
formula, like
=A4
=A5

etc

|I think you *do* get the right answer for MIN. One of your cells in A4:A36 is zero or something which is interpreted as zero by
| the MIN function.
| You can check by inserting a column in which you copy column A and format it as number.
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
|| 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
|
|

 

[Guest]

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.