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

aquarelle Posts 7181 Registration date Saturday April 7, 2007 Status Moderator Last seen July 18, 2025 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
Hello Aquarelle,

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

Best regards.
aquarelle Posts 7181 Registration date Saturday April 7, 2007 Status Moderator Last seen July 18, 2025 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
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
Thanks alot. Really helped me to solve an issue I was having
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 -