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?
Who is Participating?

Improve company productivity with a Business Account.Sign Up

Ejgil HedegaardConnect With a Mentor Commented:
Use this formula in E2, and copy down.
jamesmetcalf74Author Commented:
worked like a charm
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.