Datedif

[Ruthy Portnoy]

HI ALL.
What's wrong with the following formula? the result is

#NUM!

<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>

DATEDIF(I2,T2,"y")

 

[admiral100]

Hi,

Maybe it was not more than a year?

 

[Rick Rothstein]

HI ALL.
What's wrong with the following formula? the result is

#NUM!

<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>

DATEDIF(I2,T2,"y")

The first date must be the earlier date, try it this way...

=DATEDIF(T2,I2,"y")

 

[Ruthy Portnoy]

Thanks rick!