Date Formula

[thepartydj]

Can someone help me out in writting this formula for Excel
If the date in Column E is more than 18 months old from todays date display yes. If not display no.

Can this be done? Is it explained well enough?

Example
07/01/03 - yes
12/04/04 - no

 

[Juan Pablo González]

Try this

=IF(DATEDIF(A2,TODAY(),"m")>=18,"yes","no")