Thread: Date Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default Date Formula
in C1

=IF(B1-A1<=30,"<=30 days overdue",IF(AND(B1-A130,B1-
A1<=60),"30<overdue<=60",IF(AND(B1-A160,B1-
A1<=90),"60<overdue<=90","90 days overdue"))))

copy down, then apply autofilter
Reply With QuoteReply With Quote