Subtract Months

  • Thread starter Thread starter tkincaid
  • Start date Start date
T

tkincaid

How can I get the following in excel, I need to subtract dates and get the
total months. example 1/17/2007 - 4/18/1990 I need it to give me the total
months.
 
How many months passed between 1/30/2008 and 2/29/2008? What about 1/30/2008
and 3/1/2008?
 
Sorry for the delay, I was in a meeting, the days in the month don't have to
be counted, but I have to show as 1/1/1990, if this makes sense.
 
Rick

Thanks for your help, but don't do anything and on Thursday I will put a
copy of my sheet on here for you.
l
 
A B C D E
F G
Facility Date Report # <= 3 Mths <= 6 Mths <= 12 Mths<= 36 Mths
CAE 1/4/2007 CAE-T-07-E-001


H I J K
<= 60 Mths > 60 Mths Level Cert
87 7 10/11/1999
Rick

I hope this makes sense, I have to enter the date in column b then a date in
column k I then have to get the diffence of the two in months, I don't need
the days in the month, then they go under the correct column based on the
total of the months.

thanks

PS the other question about the command button was a guy in my office that
used my computer, I don't know what he is doing now.

thanks
 
Back
Top