calculate 18 monts from a date

  • Thread starter Thread starter Centauro
  • Start date Start date
C

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
 
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
 
Start date first so A11 must be the earlier date.


--


Regards,


Peo Sjoblom





Centauro said:
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
Click to expand...
 
Yes A11 will be always the earlier date that is way I need to calculate if 18
months has been past

Peo Sjoblom said:
Start date first so A11 must be the earlier date.


--


Regards,


Peo Sjoblom
Click to expand...
 
So what did you put in B9 and what kind of error did you get?


--


Regards,


Peo Sjoblom



Centauro said:
Yes A11 will be always the earlier date that is way I need to calculate if
18
months has been past
Click to expand...
 
Back
Top