Subtracting dates from two columns

  • Thread starter Thread starter Shannan
  • Start date Start date
S

Shannan

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.
 
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?
 
=IF(COUNT(Y15,AD15)<>2,"",IF(DATEDIF(Y15,AD15,"m")=0,"",DATEDIF(Y15,AD15,"m"))
)
best wishes
 
Back
Top