DATE
 

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

DATE
 

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

=IF(A1-B190,"3 Month is over !","")

Mike F
"Tufail" wrote in message
...
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

DATE
 

thank you very much for your quick responsed.

"Mike Fogleman" wrote:

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

=IF(A1-B190,"3 Month is over !","")

Mike F
"Tufail" wrote in message
...
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