Jim Metcalf

asked on

# 4 columns with 4 parts of a date into one column with 1 date

Attached is a spreadsheet that has 5 columns

columns 1 through 4 have the following data

1 dateyear

2 datemonth

3 dateday

4 datetime

column 5 has an entry of a desired result deduced from the information in columns 1 - 4. (i produced this by hand)

can i have a formula that will produce the result in column 5 from the information that is in columns 1 - 4?

experts-exchange.xlsx

columns 1 through 4 have the following data

1 dateyear

2 datemonth

3 dateday

4 datetime

column 5 has an entry of a desired result deduced from the information in columns 1 - 4. (i produced this by hand)

can i have a formula that will produce the result in column 5 from the information that is in columns 1 - 4?

experts-exchange.xlsx

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER