Formula DATE FORMAT Conversion

Question

hi,  i am trying to get date formats to work together..  am not that good at dates, so pardon if not on track here..

(if you need what some other date format i am using - is..  please help by specifying..)

i have a cell where i have a date format for an internet address, so need that format there:  (mo / day / year)

6/1/2012    as text?  cell eg is:    =IF(FT752>0.015,"6/1/2012",IF(OR(FT752>0.0015,1),"9/1/2015","3/1/2016"))

i am trying to get months out of that,  but:  MONTH(6/1/2012)    gets:  1   and i need:  6  (actually need how many months above eg is from today  (IF More than 1 year away..)

my excel is using:  but is how vb is printing dates so this may not matter?

2016.07.18  6:27:19 AM

=====

PROBLEM:

how many months is eg:  6/1/12  away from month today.  think would work if can get number of days / will divide by 30..

need to get 6/1/12  to register as a date..

=====

tried / not working: 

=MONTH(TEXT("9/1/2015","m/d/yyyy"))

gets a value error.  trying any combination of quote marks, number of letters for:  m d y

system clock reads:

tuesday july 19, 2016

thanks in advance..