Create a date from 3 different cells
Solved/Closed
Related:
- Excel create a date from 3 different cells
- Hitman 3 cheats - Guide
- Psiphon 3 download - Download - VPN
- Hitman 3 free download - Download - Action and adventure
- Fnia 3 - Download - Adult games
- Acer aspire 3 keyboard light - Guide
1 response
aquarelle
Posts
7140
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
March 25, 2024
491
Updated on Dec 9, 2018 at 12:48 PM
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:
and personalise your date format to have : dd-mm-yy
Best regards
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
Jun 4, 2009 at 08:00 AM
Thanks for your answer, feel kind of stupid now, but I am glad that I can continue my work.
Best regards.
Jun 4, 2009 at 02:26 PM
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
Jun 5, 2009 at 02:00 AM
May 9, 2014 at 06:15 AM
Jun 16, 2016 at 05:54 PM
Use =A1&"-"&B1&"-"&C1 ENTER.
In case you want "/" replace with -