Forum Discussion
Date formating
I'm copying and pasting data from an MS Form export into a new spreadsheet. The dates are captured as mm/dd/yy hh:mm:ss (sometimes shortened to m/d/yy h:mm:ss - for example, "2/14/22 13:40:12") When...
Thanks Riny,
I think I'm really looking for a formula that can do this, rather than a one-off process. I had seen the text-to-columns trick mentioned elsewhere, but this requires new data to be 'processed' every time you import it.
I'm ideally wanting users to be able to simply paste a row of data into one sheet and then have a formula pull this data out of the cell and 'reformat' it for them in another table... hopefully that makes sense?
Thanks in advance! 😉
I think I'm really looking for a formula that can do this, rather than a one-off process. I had seen the text-to-columns trick mentioned elsewhere, but this requires new data to be 'processed' every time you import it.
I'm ideally wanting users to be able to simply paste a row of data into one sheet and then have a formula pull this data out of the cell and 'reformat' it for them in another table... hopefully that makes sense?
Thanks in advance! 😉
joeexception See attached for a working example of a formula based solution. Not very proud if it, though. When you break it into pieces, all it does is find the date part and "calculate" the year, month and day portions and throws them into the DATE function to create a real date that you can format as you like. There must be better ways to do this, though.