how do I calculate 30, 60 90 days overdue from date invoiced

  • Thread starter Thread starter Guest
  • Start date Start date
=date+30

=date+60

=date+90

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
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?

Paul
 
Paul said:
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?
Click to expand...

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
 
Hi Paul

Assuming your days overdue are in A1
=CHOOSE(MIN(4,INT(A1/30)+1),"Current","+30","+60","+90")
 
Back
Top