Hi there,
I have attached a dummy workbook. Basically, I'm just trying to get cell E2 to display the min and max of col A
The output is always in numeric. I don't know why. Can someone help?![]()
Please Login or Register to view this content.
Hi there,
I have attached a dummy workbook. Basically, I'm just trying to get cell E2 to display the min and max of col A
The output is always in numeric. I don't know why. Can someone help?![]()
Please Login or Register to view this content.
Try it like this
=TEXT(MIN(A:A),"m/d/yyyy")&"-"&TEXT(MAX(A:A),"m/d/yyyy")
Last edited by AlKey; 01-02-2015 at 05:50 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
worked, thank you!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks