Hi,
I am trying to find a formula that will subtract the dates from two columns
and give me the difference in months. I had " =MONTH(AD15)-MONTH(Y15)", but
i've just realized that if one date is 2007-09-08 and the other is
2006-11-27, then the formula i was using does not account for the years being
different and gives me an answer of -2. How do i account for the years?
Thanks.

Shannan

I forgot to mention that if the difference is 0, i would like the cell to
remain blank instead of showing the 0.

"Shannan" wrote:

Hi,
I am trying to find a formula that will subtract the dates from two columns
and give me the difference in months. I had " =MONTH(AD15)-MONTH(Y15)", but
i've just realized that if one date is 2007-09-08 and the other is
2006-11-27, then the formula i was using does not account for the years being
different and gives me an answer of -2. How do i account for the years?
Thanks.

Shannan

See this:

http://www.cpearson.com/Excel/datedif.aspx

--
Biff
Microsoft Excel MVP


"Shannan" wrote in message
...
Hi,
I am trying to find a formula that will subtract the dates from two
columns
and give me the difference in months. I had " =MONTH(AD15)-MONTH(Y15)",
but
i've just realized that if one date is 2007-09-08 and the other is
2006-11-27, then the formula i was using does not account for the years
being
different and gives me an answer of -2. How do i account for the years?
Thanks.

Shannan

=IF(DATEDIF(Y15,AD15,"m")=0,"",DATEDIF(Y15,AD15,"m "))

where Y15 is the earlier date.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Shannan" wrote:

I forgot to mention that if the difference is 0, i would like the cell to
remain blank instead of showing the 0.

"Shannan" wrote:

Hi,
I am trying to find a formula that will subtract the dates from two columns
and give me the difference in months. I had " =MONTH(AD15)-MONTH(Y15)", but
i've just realized that if one date is 2007-09-08 and the other is
2006-11-27, then the formula i was using does not account for the years being
different and gives me an answer of -2. How do i account for the years?
Thanks.

Shannan

Hi,
this only works until i end up with one of the date cells being blank. Then
this formula gives me a "#NUM!" error. Is there a way around this?

"Luke M" wrote:

=IF(DATEDIF(Y15,AD15,"m")=0,"",DATEDIF(Y15,AD15,"m "))

where Y15 is the earlier date.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Shannan" wrote:

I forgot to mention that if the difference is 0, i would like the cell to
remain blank instead of showing the 0.

"Shannan" wrote:

Hi,
I am trying to find a formula that will subtract the dates from two columns
and give me the difference in months. I had " =MONTH(AD15)-MONTH(Y15)", but
i've just realized that if one date is 2007-09-08 and the other is
2006-11-27, then the formula i was using does not account for the years being
different and gives me an answer of -2. How do i account for the years?
Thanks.

Shannan

=IF(COUNT(Y15,AD15)<2,"",IF(DATEDIF(Y15,AD15,"m") =0,"",DATEDIF(Y15,AD15,"m"))
)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Shannan" wrote in message
...
Hi,
this only works until i end up with one of the date cells being blank.
Then
this formula gives me a "#NUM!" error. Is there a way around this?

"Luke M" wrote:

=IF(DATEDIF(Y15,AD15,"m")=0,"",DATEDIF(Y15,AD15,"m "))

where Y15 is the earlier date.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Shannan" wrote:

I forgot to mention that if the difference is 0, i would like the cell
to
remain blank instead of showing the 0.

"Shannan" wrote:

Hi,
I am trying to find a formula that will subtract the dates from two
columns
and give me the difference in months. I had "
=MONTH(AD15)-MONTH(Y15)", but
i've just realized that if one date is 2007-09-08 and the other is
2006-11-27, then the formula i was using does not account for the
years being
different and gives me an answer of -2. How do i account for the
years?
Thanks.

Shannan