Formula Error

[Shannan]

Ok, i've been posting today about the following formula, which was giving me
a "VALUE!" error. We figured out that it was because one of the cells had a
space in it. But once i went in and took the space out (so there is a value
in the more current date's cell but no value in the older date's cell), it is
now giving me an answer of 1293 for the difference between the two cells.

=IF(AD2133="","",IF(DATEDIF(Z2133,AD2133,"m")=0,"",DATEDIF(Z2133,AD2133,"m")))

AD2133 has a value of 2007-10-10 and Z2133 is blank

 

[Shannan]

I've just realized it's happening every time that there's a value in the AD
column and not in the Z column and i'm pretty sure it's because my formula
doesn't tell it to remain blank in this case. But i don't know how to change
the formula to make it work.

 

[Marcelo]

=IF(or(AD2133,z2133)="","",IF(DATEDIF(Z2133,AD2133,"m")=0,"",DATEDIF(Z2133,AD2133,"m")))

--
pleae click yes if it was helpfull
regards from Brazil
Marcelo



"Shannan" escreveu:

 

[Shannan]

If i do this formula, then when both columns AD and Z are blank, i get a
"#VALUE!" error.

 

[Jacob Skaria]

Try the belo
=IF(COUNT(AD2133,Z2133)<>2,"",IF(DATEDIF(Z2133,AD2133,"m")=0,"",DATEDIF(Z2133,AD2133,"m")))

If this post helps click Yes