Formula Error
 

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

Formula Error
 

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.

"Shannan" wrote:

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

Formula Error
 

=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:

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.

"Shannan" wrote:

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

Formula Error
 

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

"Marcelo" wrote:

=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:

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.

"Shannan" wrote:

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

Formula Error
 

Try the below
=IF(COUNT(AD2133,Z2133)<2,"",IF(DATEDIF(Z2133,AD2 133,"m")=0,"",DATEDIF(Z2133,AD2133,"m")))

If this post helps click Yes
---------------
Jacob Skaria


"Shannan" wrote:

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

"Marcelo" wrote:

=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:

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.

"Shannan" wrote:

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