Thread: how do I calculate 30, 60 90 days overdue from date invoiced
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Sune Fibaek Sune Fibaek is offline
external usenet poster
  
Posts: 38
Default how do I calculate 30, 60 90 days overdue from date invoiced
"Paul" wrote:

Thanks Bob,

I have the days over due, I need to classify the number into current, +30
day, +60day or +90 days over due categories. Can you help me there?

With the values 1,2,3 in D1:D3 and 30,60,300 (large number) in E1:E3 and
90+,60+,30+ in F1:F3 try:

=VLOOKUP(MATCH(A1;$E$1:$E$3;-1);$D$1:$F$3;3;FALSE)

HTH,

/Sune



Reply With QuoteReply With Quote