DATE

[Guest]

hi
i am trying to make following formula detail is A_col has today date B_col
has some older dates i need result in C_col, if B_col date older than 90 days
of A_col

A_col B_col C_col
07/01/2006 02/01/2006 3 Month is over !
07/01/2006 05/25/2006 -

thanks in advance.
tufail

 

[Mike Fogleman]

Put this formula in C1 and drag fill-down as far as necessary.

=IF(A1-B1>90,"3 Month is over !","")

Mike F

 

[Guest]

thank you very much for your quick responsed.

Put this formula in C1 and drag fill-down as far as necessary.

=IF(A1-B1>90,"3 Month is over !","")

Mike F