calculate 18 monts from a date
 

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

calculate 18 monts from a date
 

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

--
Regards
Roger Govier

"Centauro" wrote in message
...
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

calculate 18 monts from a date
 

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

"Roger Govier" wrote:

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

--
Regards
Roger Govier

calculate 18 monts from a date
 

Start date first so A11 must be the earlier date.


--


Regards,


Peo Sjoblom





"Centauro" wrote in message
...
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

"Roger Govier" wrote:

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

--
Regards
Roger Govier

calculate 18 monts from a date
 

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

"Peo Sjoblom" wrote:

Start date first so A11 must be the earlier date.


--


Regards,


Peo Sjoblom





"Centauro" wrote in message
...
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

"Roger Govier" wrote:

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

--
Regards
Roger Govier

calculate 18 monts from a date
 

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


--


Regards,


Peo Sjoblom



"Centauro" wrote in message
...
Yes A11 will be always the earlier date that is way I need to calculate if
18
months has been past

"Peo Sjoblom" wrote:

Start date first so A11 must be the earlier date.


--


Regards,


Peo Sjoblom





"Centauro" wrote in message
...
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

"Roger Govier" wrote:

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

--
Regards
Roger Govier