How to Create a date from 3 different cells?

Last update on November 3, 2009 10:28 AM by aakai1056
Published by aakai1056

How to Create a date from 3 different cells?




Issue



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?

Solution


To do this, please use this 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

Note


Thanks to aquarelle for this tip on the forum.
Best answers for « How to Create a date from 3 different cells? » in :
Copying data into different cells using macro Show
Create a date from 3 different cells Show
Creating database under Ingres Show Creating database under Ingres Intro Example createdb Intro Ingres is a relational database management system (RDBMS) that is based upon a research project from the University of California at Berkeley . There are two different...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
[Excel] Adding a fixed date in a cell Show[Excel] Adding a fixed date in a cell If you want to insert the current date in a cell in following format DD /MM/YYYY, and that it remains unchanged, without being updated each time the file is opened. Simply type "ctrl" + ";" in the...
Inserting an Hyperlink in an Excel Worksheet ShowCreating an Hyperlink in an Excel Worksheet Introduction Implementation Linking to a Website Linking to a document Linking to another cell in the spreadsheet Notes Introduction Excel supports the use of hyperlinks and it is a very...
Data transmission - Transmission modes ShowTransmission modes A given transmission on a communications channel between two machines can occur in several different ways. The transmission is characterised by: the direction of the exchanges the transmission mode: the number of bits sent...
They need your help