Forum Discussion
Solved
How to please.
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?
- You could try this and format as a date:
=Date(C1, B1, A1)
- You could try this and format as a date:
=Date(C1, B1, A1)- Thanks so much.
