Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 661
Default how do I calculate 30, 60 90 days overdue from date invoiced


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 661
Default 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   Report Post  
Posted to microsoft.public.excel.misc
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



  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 661
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,886
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to I calculate 180 days from any date? Jackie Excel Worksheet Functions 2 April 3rd 23 07:32 PM
Apply green to current date, red to 2 days overdue and none if pai vpschas Excel Worksheet Functions 16 September 7th 06 02:35 PM
Auto calculate for date + days forward to yield new date John Sullivan Excel Worksheet Functions 1 April 22nd 06 05:18 PM
formula to calculate future date from date in cell plus days Chicesq Excel Worksheet Functions 8 November 3rd 05 01:25 PM
How do I calculate 30 days later from a date SYH Excel Worksheet Functions 1 August 2nd 05 04:17 AM


All times are GMT +1. The time now is 08:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"