Hi
i have dates in a1,b1,c1. I want those 3 dates to appear in cell e1.
eg: a1=5/8/1984, b1=6/7/2013, c1=4/8/2010
Result = 5/8/1984,6/7/2013,4/8/2010
(in cell e1).
Thank you.
Hi
i have dates in a1,b1,c1. I want those 3 dates to appear in cell e1.
eg: a1=5/8/1984, b1=6/7/2013, c1=4/8/2010
Result = 5/8/1984,6/7/2013,4/8/2010
(in cell e1).
Thank you.
You can try this.....
=TEXT(A1,"MM/DD/YYYY")&","&TEXT(B1,"MM/DD/YYYY")&","&TEXT(C1,"MM/DD/YYYY")
Change the date format in the Text function as required.
I hope it helps.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks