JJones_hay
New Member
- Joined
- Dec 5, 2012
- Messages
- 18
Guys, I have some horrible extract data with differing date formats that I need to convert to something consistent that I can format as a date.
This is an example of data.... all with general format at the moment.
<tbody>
</tbody>
I have used this formula to extract the date portion, but I can't get this to then format as date. How do I convert this to the julian date, so I can then apply a date format?
=LEFT(G9,SEARCH("/",G9)+7)
(The day portion of this date always has a leading zero)
Thanks
This is an example of data.... all with general format at the moment.
2/28/2013 2:48:53 PM |
1/16/2013 10:48:50 AM |
12/17/2012 11:59:49 AM |
<tbody>
</tbody>
I have used this formula to extract the date portion, but I can't get this to then format as date. How do I convert this to the julian date, so I can then apply a date format?
=LEFT(G9,SEARCH("/",G9)+7)
(The day portion of this date always has a leading zero)
Thanks