Thread
:
Combine month day and year from separate columns in to one cell
View Single Post
#
3
Posted to microsoft.public.excel.misc
Peo Sjoblom
external usenet poster
Posts: 3,268
Combine month day and year from separate columns in to one cell
=TEXT(--(A1&" "&B1&", "&C1),"mm/dd/yy")
--
Regards,
Peo Sjoblom
"Thanks, JH" <Thanks,
wrote in message
...
I have the month (October), day (3), and year (2005) contained in three
cells. I want to combine them into one cell where I can have the date as
10/3/2005. I have been unsuccessful using concatenate because I cannot
change the format of the finished project from 10/3/2005 to Oct-3,2005
etc.... I need to perform this so that I can calculate the days between
the
specified date and a start date.
Reply With Quote
Peo Sjoblom
View Public Profile
Find all posts by Peo Sjoblom