LinkBack URL
About LinkBacks
I am trying to reference a cell formatted as "date" for the type in a CONCATENATE function, and it's returning the DATEVALUE for that referenced cell (ie: 39993 instead of 6/29/09 is showing). How do I reverse the datevalue function?
Thanks
I am trying to reference a cell formatted as "date" for the type in a CONCATENATE function, and it's returning the DATEVALUE for that referenced cell (ie: 39993 instead of 6/29/09 is showing). How do I reverse the datevalue function?
Thanks
Use the TEXT function to display per your requirements... in simple terms:
A1: 6/29/09
B1: ="Date is "&TEXT(A1,"m/d/yy")
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
If I understand you, perhaps like so:
=TEXT(H1,"M/D/YY") & " - " & TEXT(H2,"M/D/YY")
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Originally Posted by DonkeyOte
Thank you worked perfectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks