Thread: DATE
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tufail Tufail is offline
external usenet poster
 
Posts: 168
Default 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