Previous Topic Next Topic

Create a date from 3 different cells

Solved/Closed
Trowa - Jun 2, 2009 at 08:42 AM
 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?
Related:

1 response

Answer 1 / 1
aquarelle Posts 7141 Registration date Saturday April 7, 2007 Status Moderator Last seen December 19, 2024 491
Updated on Dec 9, 2018 at 12:48 PM
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
62
Trowa
Jun 4, 2009 at 08:00 AM
Hello Aquarelle,

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

Best regards.
0
aquarelle Posts 7141 Registration date Saturday April 7, 2007 Status Moderator Last seen December 19, 2024 491 > 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
0
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 166
Jun 5, 2009 at 02:00 AM
@Aquarelle nice tip
2
Flipper
May 9, 2014 at 06:15 AM
Thanks alot. Really helped me to solve an issue I was having
0
Sid > mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010
Jun 16, 2016 at 05:54 PM
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 -
0