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
|