return date format in function

[Matthew Dyer]

function reads - ="Last Updated "&(MAX(MTD!I:I)) - is there any way
to modify the function to the MAX value i'm looking for is read as a
date? currently returns "Last Updated 40490", would like it to return
"Last Updated 8-Nov-10"

 

[Jim Cone]

The Text function will do that.
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware

..
..
..

"Matthew Dyer" <[email protected]>
wrote in message
function reads - ="Last Updated "&(MAX(MTD!I:I)) - is there any way
to modify the function to the MAX value i'm looking for is read as a
date? currently returns "Last Updated 40490", would like it to return
"Last Updated 8-Nov-10"

 

[Gord Dibben]

="Last Updated "&TEXT(MAX(Day!I:I),"dd-mmm-yy")


Gord Dibben MS Excel MVP

 

[Matthew Dyer]

="Last Updated "&TEXT(MAX(Day!I:I),"dd-mmm-yy")

Gord Dibben     MS Excel MVP



- Show quoted text -

Wow... I feel kinda silly for not figuring this out on my own. Thanks
for the help guys!!!

 

[Gord Dibben]

Don't feel too silly.

Making use of the TEXT function when working with dates/times(which are numeric)
is not intuitive IMO


Gord