how to convert string into readable format for =DATEVALUE?

[lougs7]

Hi all,


please view image to understand what i'm talking about!

I imported billing dates into my master file (column B), using logic in excel I broke up the string of the billing period to properly identify the Start and End dates. Now I would like to convert these strings in columns D and E into actual recognized dates in Excel so I can reference these dates in =netwokringdays and other formulas. I tried using the =DATEVALUE function but it returns a #VALUE error. I am not sure why because the format mm/dd/yyyy is one that the function should recognize.


can someone tell me how to convert columns D and E into Excel Dates using a formula, not manually? maybe it is the syntax that is wrong? maybe there is another formula that can be used? I am really stuck here and could use any help appreciate your time guys

 

[Jonmo1]

Welcome to the board.

Pictures don't really help alot.
A) Some (many) people here can't even see them due to firewall restrictions
B) We can't copy/paste stuff from a picture into our own books for troubleshooting.

Can you post a few examples of the original string (prior to extracting dates with mid type functions)

 

[blzbub]

Hi. It may be the cell format? I have just typed in exactly what your query is and got a result as below - all cells formatted to "general"

[TABLE="width: 460"]
<tbody>[TR]
[TD="colspan: 4"]10/19/2014 - 11/1/2014 (Final invoice)[/TD]
[TD="colspan: 2"]11/1/2014 [/TD]
[TD="align: right"]41944[/TD]
[/TR]
</tbody>[/TABLE]

 

[Smitty]

Welcome to the Board!

If you follow the HTML Maker link in my sig you'll be able to post screen shots.