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

- - 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 

1 reply

Best answer
approved by Jean-François Pillou on Dec 9, 2018
Posts
7238
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
October 3, 2019
486
61
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

Say "Thank you" 61

A few words of thanks would be greatly appreciated. Add comment

CCM 6350 users have said thank you to us this month

TrowaD
Posts
2535
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 15, 2019
368 -
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.
vcoolio
Posts
1251
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 29, 2019
205 > TrowaD
Posts
2535
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 15, 2019
-
You did it for me TrowaD and I became hooked.
Its all your fault!
Ambucias
Posts
51365
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
October 12, 2019
12731 > vcoolio
Posts
1251
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 29, 2019
-
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.
Thanks a lot.