eSourceCity
New Member
- Joined
- Apr 28, 2014
- Messages
- 5
How can I show a date in the format YYYY-MM-DD referencing cells from a different sheet when the referenced cells are written as text using the following two formats:
1) 2014-04-23T16:38:06.000Z (currently formatted as "general")
2) 4/21/2014 9:09:52 PM (currently formatted as custom - m/d/yyyy h:mm
<tbody>
</tbody>
For example, the above table, what would be the single formula that would return the requested format YYYY-MM-DD for each row.
1) 2014-04-23T16:38:06.000Z (currently formatted as "general")
2) 4/21/2014 9:09:52 PM (currently formatted as custom - m/d/yyyy h:mm
A | B | ||
1 | Raw Date | Formatted Date | |
2 |
<tbody> </tbody> | ||
3 | 2014-04-22T15:32:38.000Z | ||
4 | 4/21/2014 22:24 | ||
5 | 2014-04-22T18:32:05.000Z | ||
6 |
<tbody> </tbody> | ||
7 | 4/21/2014 23:39 |
<tbody>
</tbody>
For example, the above table, what would be the single formula that would return the requested format YYYY-MM-DD for each row.