Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I calculate 30, 60 90 days overdue from date invoiced
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I calculate 30, 60 90 days overdue from date invoiced
=date+30
=date+60 =date+90 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Paul" wrote in message ... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I calculate 30, 60 90 days overdue from date invoiced
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 "Bob Phillips" wrote: =date+30 =date+60 =date+90 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Paul" wrote in message ... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I calculate 30, 60 90 days overdue from date invoiced
I got, I had to use an =IF(AND) statement.
Thansk for all your help. "Sune Fibaek" wrote: "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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I calculate 30, 60 90 days overdue from date invoiced
Hi Paul
Assuming your days overdue are in A1 =CHOOSE(MIN(4,INT(A1/30)+1),"Current","+30","+60","+90") -- Regards Roger Govier "Paul" wrote in message ... 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 "Bob Phillips" wrote: =date+30 =date+60 =date+90 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Paul" wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to I calculate 180 days from any date? | Excel Worksheet Functions | |||
Apply green to current date, red to 2 days overdue and none if pai | Excel Worksheet Functions | |||
Auto calculate for date + days forward to yield new date | Excel Worksheet Functions | |||
formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
How do I calculate 30 days later from a date | Excel Worksheet Functions |