SOLVED

How to please.

New Contributor

I have a worksheet which contains dates for invoices but I have them in separate columns i.e. Col A contains Day then Col B contains Month & Col C contains Year. 

 

These 3 columns are formatted as a number.  I want to have another Col, Col D look at the other 3 columns and then add them to it (Col D), in date format.  

 

I also want to keep the 3 original columns as other sheets in my workbook refer to these columns.  Is there anyway possible of doing this?

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution
You could try this and format as a date:
=Date(C1, B1, A1)
Thanks so much.