Hi, I have a list with 'Item Number' and 'Date Sale'.
| Item | Date |
| Item 03 | 13/08/2013 |
| Item 06 | 12/08/2013 |
| Item 05 | 11/08/2013 |
| Item 09 | 10/08/2013 |
| Item 01 | 15/07/2013 |
| Item 03 | 05/07/2013 |
First, I calculate the interval in days between any date write by the user and the 'Date Sale'. If the user write the date (dd/mm/yyyy) 10/10/2013, then:
| Item | Date | Interval (days) |
| Item 03 | 13/08/2013 | 58 |
| Item 06 | 12/08/2013 | 59 |
| Item 05 | 11/08/2013 | 60 |
| Item 09 | 10/08/2013 | 61 |
| Item 01 | 15/07/2013 | 87 |
| Item 03 | 05/07/2013 | 97 |
But instead the interval number, I show a label:
'1-29 Days'
'30-59 Days'
'60-89 Days'
'>= 90 Days'
| Item | Date | Interval |
| Item 03 | 13/08/2013 | 30-59 days |
| Item 06 | 12/08/2013 | 30-59 days |
| Item 05 | 11/08/2013 | 60-89 Days |
| Item 09 | 10/08/2013 | 60-89 Days |
| Item 01 | 15/07/2013 | 60-89 Days |
| Item 03 | 05/07/2013 | >= 90 Days |
And (this is the problem) I need to select which interval to show, by example only show the Items with interval '>= 90 days' or intervals '1-29 Days' and '60-89 Days'. Remember that the user can write any date.
Attached a sample file, thanks.
