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?

--
Rick (MVP - Excel)


"tkincaid" wrote in message
...
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.

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 Rothstein" wrote:

How many months passed between 1/30/2008 and 2/29/2008? What about 1/30/2008
and 3/1/2008?

--
Rick (MVP - Excel)


"tkincaid" wrote in message
...
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.

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

"tkincaid" wrote:

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 Rothstein" wrote:

How many months passed between 1/30/2008 and 2/29/2008? What about 1/30/2008
and 3/1/2008?

--
Rick (MVP - Excel)


"tkincaid" wrote in message
...
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.

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


"tkincaid" wrote:

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

"tkincaid" wrote:

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 Rothstein" wrote:

How many months passed between 1/30/2008 and 2/29/2008? What about 1/30/2008
and 3/1/2008?

--
Rick (MVP - Excel)


"tkincaid" wrote in message
...
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.