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

B

Bob Phillips

=date+30

=date+60

=date+90

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
P

Paul

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
 
S

Sune Fibaek

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
 
R

Roger Govier

Hi Paul

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use/create code in MS Word to calculate age? 0
Conditional Format where ANY date is >= 30, 60, 90 days EXCEL 2007 1
Calculate 60 days from Start Date - including weekends 5
How do I set up alternate row shading with Excel 2003? 8
How to add 30, 60 and 90 days to date and calculate deepening disc 5
can the "convert" function in excel convert to UK gallons? 1
Just create it regardless with error handling 3
Avoiding Leads, using SVT, and Linking Tasks correctly 0

Top