We have a requirement of 5 sales a day.
I have an excel 2003 sheet as follows with each user sales:

21 May|5
22 May|4
23 May|5
29 May|6
30 May|2
1 June |5
5 June |4

I want to [custom] filter the list to contain all values between 22 May and 4 June (for example) and I would like a cell that states
1)"Should have made this many sales", another that states
2)"has made this many sales" and another that states
3)"this many sales to make up".

2) is fine with a subtotal fx of column b and 3) is just 1) minus 2) but I am having issues with 1). What I currently am doing is subtracting the min from max of the subtotal of column a. However, this will only work if the dates picked in the autofilter actually exist in the log (a user could be away on the last few days of the upper limit, as in the example) and if that is not the case then it will state the number of sales that should have been made while the user has been logged.

Two unreasonable solutions:
a)Type the values in the custom autofilter field and in two other cells and have 1) and 3) reference these cells;
b)After the autofilter values have been typed, check to see if the upper and lower values appear in the log otherwise, just type them below.

Suggestied solution:
type the values in seperate cells and have the autofilter pick up these values? (I have read this: http://www.excelforum.com/excel-prog...e-in-cell.html but it is not what I am looking for).

Any reasonable solutions? I'm trying to do this without macros. Although I know how to write macros, I do not want to confuse the users with the dialog boxes and buttons.

THANK YOU!!