how to subtract dates with text in the

[bell_man]

I added a pic to clarify A2 comes from a vlookup so im trying to figure out how to either 1.Return the date only from the vloopup or 2. subtract A2-B2

[FDibbins]

Or Maybe a vlookup formula to only return the date and not the text character?

That sounds like a better option,otherwise you will need a formula to 1st remove the text, then do the subtraction. In fact, if you are using vlookup to find the dates, why not use the same thing for the calc, just leave out the text?

[rcm]

Please Login or Register  to view this content.

This simple formula works if there is only one character there

[bell_man]

edited the original post

[FDibbins]

This should do what you need...
=B2-DATEVALUE(LEFT(A2,LEN(A2)-1))

(note: there is not 31 days in Feb :0 )

[bell_man]

that did it you are the man

[newdoverman]

You have an impossible date in B2. What should it be?

[newdoverman]

Ok just inserting a real date:
Select column B and the click on the Data tab, Text to columns, click NEXT NEXT , select DATE MDY, click finish. This will convert the value to a real date.

Choose the formula to give the number that you are looking for.
Enter this in C2 to give the number of dates BETWEEN the first and last dates but not including either date.

Please Login or Register  to view this content.

This includes both the start and end dates

Please Login or Register  to view this content.

This includes the last date but not the first.

Please Login or Register  to view this content.

[newdoverman]

B2 is also something that isn't a date. I can't determine exactly what it is but this will straighten it out. (works with dd/mm/yyyy date format)

Please Login or Register  to view this content.

This should work with date format of mm/dd/yyyy

Please Login or Register  to view this content.

[bell_man]

sorry about the date. It works when you use the an actual date.