Nokia C3: How to combine Month/Day/Year seperately in a different column in Microsoft Excel.

How to combine Month/Day/Year seperately in a different column in Microsoft Excel.
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
#2
Old 13-01-2012
Bontu Bontu is offline
Member

Join Date: May 2011
Posts: 500
Re: How to combine Month/Day/Year seperately in a different column in Microsoft Excel.
Here is a short formula the same. Type =date(year,month,day), assuming you have on a1 2005; b1 10; c1 3 use =date(a1,b1,c1). Or else try this =TEXT(--(A1&" "&B1&", "&C1),"mm/dd/yy"). And for using the DATA Function = DATE (C1, B1, A1) which is Written out as = Date (year, month, day).
Reply With Quote
#3
Old 13-01-2012
GaganjyotTechie GaganjyotTechie is offline
Member

Join Date: May 2011
Posts: 433
Re: How to combine Month/Day/Year seperately in a different column in Microsoft Excel.
There is some things you can try. See the below example :

* A1: (a month name....eg October)
* B1: (a day of the month...eg 3
* C1: (a year......eg 2005)
* This formula returns a data based on those inputs:
* D1: =--(B1&"-"&A1&"-"&C1)
* Format D1 as a date.

In the above example, D1 returns 10/03/2005. Is that something you can work with? Post back if you have more questions.
Reply With Quote