return date format in function

  • Thread starter Thread starter Matthew Dyer
  • Start date Start date
M

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"
 
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"
 
="Last Updated "&TEXT(MAX(Day!I:I),"dd-mmm-yy")

Gord Dibben     MS Excel MVP



- Show quoted text -
Click to expand...

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

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


Gord
 
Back
Top