calendar component

Hi,

I want my user to select the date range in dashboard. I am using calendar component for that. The user will select the "From date" and the "To date".

I have a table in my excel sheet (within the dashboard). Based on the date the user selects the data in the table must be filtered and displayed in the datshboard via a ListView.

I have a challenge here,

1. When a user select a date (Ex: 24/06/2012) then in the destination cell of the excel sheet only some numeric value appears instead of date. Why is this so ? How to overcome this, also, based on this selected date, i need to apply this date as the filter for my ListView.

Regards,

Lakshminarasimhan.N