Oct 12 2022 05:51 PM
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?
Oct 12 2022 06:17 PM
SolutionOct 12 2022 06:17 PM
Solution