| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
3 cells into 1 date?
Thank you both..these solutions were like a dream!
Allan "OssieMac" wrote: Hi Al, Are you looing for a macro to automate this for you or simply the formula to do it on the worksheet? On the worksheet you could format a column to a date "dd/mm/yyyy" and then use the following formula:- =VALUE(A7&"/"&A8&"/"&A9) Regards, OssieMac "Al" wrote: I have inherited a spreadsheet that contains columns of numbers to represent a day (dd), columns with numbers for month (mm) and another with the year (yyyy) How can I combine the 3 cells in a row to produce a date cell (dd/mm/yyyy)? e.g. A7 = 7 A8 = 5 A9 = 2001 but I need 07/05/2001 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return a date from range, date is between dates in two other cells | Excel Discussion (Misc queries) | |||
| Count number of cells with date <today's date | New Users to Excel | |||
| count the number of cells with a date <= today's date | New Users to Excel | |||
| Sum Cells within each date. | Excel Worksheet Functions | |||
| how do I format cells to change date and time to just date | Excel Discussion (Misc queries) | |||
Threaded Mode
