NateW
10-18-2007, 10:29 AM
Hi, Folks...
I'm trying to populate a schedule by taking specific information from another spreadsheet.
This is no problem, but where I'm stumped is that I'm trying to take date information from the source worksheet, which is in this format:
8/7/2007 8:00:00 AM
and put it into the target location as
8/7/2007
I have a feeling that "mid" won't work, due to the fact that the number of characters in the date changes from the mimimum above, to something like:
12/12/2007
and everything in between...
So, I'm guessing I can do a format change to the date, to make it date only, instead of date/time, but I'm not sure how to do that.
Any ideas?? Thanks so much in advance for any help!!
I'm trying to populate a schedule by taking specific information from another spreadsheet.
This is no problem, but where I'm stumped is that I'm trying to take date information from the source worksheet, which is in this format:
8/7/2007 8:00:00 AM
and put it into the target location as
8/7/2007
I have a feeling that "mid" won't work, due to the fact that the number of characters in the date changes from the mimimum above, to something like:
12/12/2007
and everything in between...
So, I'm guessing I can do a format change to the date, to make it date only, instead of date/time, but I'm not sure how to do that.
Any ideas?? Thanks so much in advance for any help!!