3 cells into 1 date?

G

Guest

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

Guest

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

Convert text date to mmddyyy date 2
Formatting Dates from Text to Numbers 2
Date Format 2
Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y 2
Date Formatting Error 1
create a month column from date column 4
Date Format and Sumproduct 9
Date Formatting in Excel Urgent 1

Top