Anthony_2905
New Member
- Joined
- Jan 18, 2014
- Messages
- 2
Okay, so the data I'm looking at exports in this format "10/1/2013 9:25:00 AM", which I need to convert to "10/1/13", or something similar, stripping out the time element. The obvious answer, format cells/date is not helpful, as I need to manipulate the exported data in a pivot table, which would just revert the formatted value back to a timestamp.
My question: does anyone know a formula that will change 10/1/2013 9:25:00 AM to 10/1/13, so that when I look to display three months of data, I have around 90 date values, and not 3,000 or so? I Google'd this once before and found it, but I can't find it again. I do not work with any macro's, backend coding, etc., so please someone post a formula for this and I will be much appreciative!
My question: does anyone know a formula that will change 10/1/2013 9:25:00 AM to 10/1/13, so that when I look to display three months of data, I have around 90 date values, and not 3,000 or so? I Google'd this once before and found it, but I can't find it again. I do not work with any macro's, backend coding, etc., so please someone post a formula for this and I will be much appreciative!