Create a date from 3 different cells [Solved/Closed]

- Jun 2, 2009 at 08:42 AM - Latest reply:  Udeni
- Jul 13, 2017 at 05:45 PM
Hello,

In excel I have date spread across 3 cells; 1 with the day (A1), 1 with the month (A2) and 1 with the year (A3).
I want to put these 3 numbers into one cell as a date (A4).
A1 A2 A3 A4
15 11 09 15-11-09

I've looked at the "date and time" functions, but can't find anything.

Does anyone know a function or a VBA code that will solve my issue?
See more 

11 replies

Best answer
Posts
7179
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
October 25, 2018
- Jun 2, 2009 at 03:01 PM
59
Thank you
Hello,
Use the formula DATE(year,month,day) in your case, write this formula into A4:
=DATE(C1,B1,A1)
and personalise your date format to have : dd-mm-yy

Best regards

Thank you, aquarelle 59

Something to say? Add comment

CCM has helped 1662 users this month

Hello Aquarelle,

Thanks for your answer, feel kind of stupid now, but I am glad that I can continue my work.

Best regards.
Posts
7179
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
October 25, 2018
> Trowa - Jun 4, 2009 at 02:26 PM
Hi,
Why stupid ? There are so many formulas in excel that it's difficult to know all of them.
Even if, I often use excel, I don't know all the formulas and sometime, like you, I need help and I post my request on a forum, waiting somebody replies. Certainly, some will find the request simple because they know but when we don't know it is not simple :)
This forum has been created to find these sort of help and to learn what we don't know. Do not hesitate to post a new thread if you need help for something else.
Best regards
Thanks alot. Really helped me to solve an issue I was having
Thanks a lot.
Posts
191
Registration date
Sunday April 12, 2009
Last seen
February 16, 2010
- Jun 5, 2009 at 02:00 AM
2
Thank you
@Aquarelle nice tip
Hi you can use " &" for eg A1,B1,C2 has your day month & year

Use =A1&"-"&B1&"-"&C1 ENTER.

In case you want "/" replace with -
Posts
2447
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 15, 2018
- May 30, 2017 at 11:09 AM
0
Thank you
Funny coming across this thread again. I believe this is my first post ever on this site and Aquarelle's kind reply got me hooked. Have been trying to do the same for others ever since.
Posts
1204
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
November 11, 2018
- May 30, 2017 at 06:11 PM
You did it for me TrowaD and I became hooked.
Its all your fault!
Posts
55829
Registration date
Monday February 1, 2010
Last seen
November 16, 2018
>
Posts
1204
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
November 11, 2018
- May 30, 2017 at 06:22 PM
Funny, I can't get hooked to Excel. I must be more of an intellectual, a philosopher, a poet, a nature lover, a wanderer...peace on earth to all men of good will and the heck with the others.