PDA

View Full Version : Exporting Dates into excel



happy_smiler1
2017-10-30, 01:55 PM
Hi All,

Im having troubles with dates, on one spreadsheet there is data that i recieved from a colleague, I use that spreadsheet and copy the information into a new spreadsheet to manipulate the data, but when I paste into my new workbook, the dates change format, some are "general" others are "custom" then I have others which are date only, is there a way of being able to extract the date and the time separately as when I have tried using =left and the =date functions it doesnt seem to work on the "custom" formatted dates. I have attached a workbook if anybody could help.

Thanks.

NBVC
2017-10-30, 02:45 PM
Try these:

=DATE(YEAR(A2),MONTH(A2),DAY(A2))

=TIME(HOUR(A2),MINUTE(A2),SECOND(A2))

You may need to format the results as Date and Time respectively

happy_smiler1
2017-10-31, 12:17 AM
Hi NBVC, this worked. Thank you so much, much appreciated.