Hi,

I have a problem with this:

I have a worksheet named Sales historical data:
Column A: Dates
Column B: Phone Description
Column C: Sales quantity

I need to get the total sales quantity for 5 days.
On the left hand side, i want to create a calender in which i can choose the
date. then on the right hand side, i want to create another calender in which
i can choose the date again.
So when i choose a date in both calender like for example, 17 Feb 2010 to 21
Feb 2010, the TOTAL sales quantity for all the 5 days will appear below.

Can anyone assist me?

If cannot, is there any other alternatives?

Thank you!!!!!!