Combine month day and year from separate columns in to one cell
=date(year,month,day)
assuming you have on a1 2005; b1 10; c1 3
use =date(a1,b1,c1)
hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo
"Thanks, JH" escreveu:
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.
|