3 cells into 1 date?

A

Al

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
 
P

Peo Sjoblom

In a 4th cell put

=DATE(A9,A8,A7)

Don't know if I got the order right for A7 and A8

it should be

-DATE(year,month,day)
 
O

OssieMac

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting Dates from Text to Numbers 2
Convert text date to mmddyyy date 2
Check dates against a date range. 0
create a month column from date column 5
Date Format and Sumproduct 9
years-months-days-hours 8
Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y 3
Excel 2007 text import as text not date 3

Top