Guys i really need help with this one i got the data in this format and need to get it as date in order to make a substract from a today formula minus that date in that format, if it helps this is data imported from a website.
Guys i really need help with this one i got the data in this format and need to get it as date in order to make a substract from a today formula minus that date in that format, if it helps this is data imported from a website.
The problem is you have a space after the date. You can either do a find and replace for "2009 " (without quotation marks) and replace with "2009" or you can use =TODAY()-(LEFT(A2,LEN(A2)-1)) as your formula.
It's not a regular space, either, so replacing "2009 " with "2009" probably won't work. It's a non-breaking space (char 160).
DY's formula would still work, though.
Another option is:
=TODAY()-SUBSTITUTE(A2,CHAR(160),"")
Mmm is not working i keep getting #Value! error, someone knows why?
Please post an example workbook. I tried my formula with the one you had originally posted and it works fine.
Perhaps is something with my excel config?
No, the formula is working fine. Format the result cell to a number format and you'll get 3.
Dude already did it, here's a Print screen of what i get in my excel i don't know why i keep getting the error i believe you, but perhaps is something else with the config i don't know.
The formula is working fine for me in the workbook you have posted. When I run through the formula evaluator, I see the same thing as you, but when it finishes I get the value 3, not an error.
Are you running the English U.S. version of Office with U.S. regional settings? Only thing I can think of is that Excel isn't recognizing the date format of "December 7, 2009".
That was the issue, thanks a bunch guys!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks