View Single Post
  #1   Report Post  
Eric
 
Posts: n/a
Default Extract date from cell

If I had a cell that contains the following:
Delivered 11/24

Is there some way I can tell another cell to subtract just the date
from another date? For instance, if the other cell has 10/25 in it, I
want to use a datedif function to tell me the number of days between
the two dates (i.e. datedif(a1,a2,"d"). A1 is the cell with 10/25 in
it, and a2 is the cell with delivered 11/24 in it. I need a formula
in place of a2 that will look past the word delivered and retrieve the
date so it can complete the formula.

Any ideas?