Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting wrong values | Excel Worksheet Functions | |||
How do I recover data that somebody pasted over on the wrong page | Excel Discussion (Misc queries) | |||
SUMPRODUCT is showing wrong Amount | Excel Discussion (Misc queries) | |||
hyperlink navigation path path wrong in Excel 2003 | Excel Discussion (Misc queries) | |||
What am I doing wrong? | Excel Worksheet Functions |