Shadyguy904
New Member
- Joined
- Jan 24, 2008
- Messages
- 21
I need a formula that will help determine what "bucket" (based on today's date & due date) a date would fall under. I have 5 buckets:
RRC
0-14 Days
15-22 Days
23-30 Days
31+ Days
I am using the following formula:
=IF(D2="","N/A",IF(TODAY()-D2<-25,"RCC",IF(AND(TODAY()-D2>-26,TODAY()-D2<-11),"0 - 14 days",IF(AND(TODAY()-D2>-12,TODAY()-D2<-4),"15 - 21 days",IF(AND(TODAY()-D2>-5,TODAY()-D2<1),"22 - 30 days",IF(TODAY()-D2>0,"31 + days"))))))
This formula works fine, however the next day I run the report the formula has to be slightly modified to place everything in the correct aging "bucket". Is there a formula that would alleviate the need to update the formula everytime I would like to check the inventory?
The dates are actually based on a weekly (Sunday through Saturday) schedule. So if the Due date is Prior to today's date it would fall into the 31+ category. If due up to 14 days (including today) it would fall under the 0-14 Day "bucket". And so on...
Any help is greatly appreciated.
RRC
0-14 Days
15-22 Days
23-30 Days
31+ Days
I am using the following formula:
=IF(D2="","N/A",IF(TODAY()-D2<-25,"RCC",IF(AND(TODAY()-D2>-26,TODAY()-D2<-11),"0 - 14 days",IF(AND(TODAY()-D2>-12,TODAY()-D2<-4),"15 - 21 days",IF(AND(TODAY()-D2>-5,TODAY()-D2<1),"22 - 30 days",IF(TODAY()-D2>0,"31 + days"))))))
This formula works fine, however the next day I run the report the formula has to be slightly modified to place everything in the correct aging "bucket". Is there a formula that would alleviate the need to update the formula everytime I would like to check the inventory?
The dates are actually based on a weekly (Sunday through Saturday) schedule. So if the Due date is Prior to today's date it would fall into the 31+ category. If due up to 14 days (including today) it would fall under the 0-14 Day "bucket". And so on...
Any help is greatly appreciated.