calculate 18 monts from a date

[Centauro]

Hi I need to calculate from une date if 18 monts has past, if is false put a
"X" on if is true livet in blank (no 0 )
ex

Kevin start on 06 mai 2007 still no 18 monts = "X"
Tony start on 03 fev 2007 hi pas 18 monts = " "


tanks

 

[Roger Govier]

Hi
=IF(DATEDIF(A11,TODAY(),"m")<18,"X","")

 

[Centauro]

Thanks but what if I want to compare to another date in B9 for ex
i tray
=IF(DATEDIF(A11,B9,"m")<18,"X","")
and gime a error

Tks

 

[Peo Sjoblom]

Start date first so A11 must be the earlier date.


--


Regards,


Peo Sjoblom

Thanks but what if I want to compare to another date in B9 for ex
i tray
=IF(DATEDIF(A11,B9,"m")<18,"X","")
and gime a error

Tks

 

[Centauro]

Yes A11 will be always the earlier date that is way I need to calculate if 18
months has been past

Start date first so A11 must be the earlier date.


--


Regards,


Peo Sjoblom

 

[Peo Sjoblom]

So what did you put in B9 and what kind of error did you get?


--


Regards,


Peo Sjoblom

Yes A11 will be always the earlier date that is way I need to calculate if
18
months has been past