On Sunday, October 27, 2013 11:15:24 PM UTC-7, amy chan wrote:
I would like to create a excel file to let the user to input the
following column.

Date No. of success No. of failure
==== ============ ==============
" " "
" " "
" " "
Could advise if I would like to have a function that can allow the user
to select the date range and its total no. of success and no. of
failure

With the data above in columns A, B, C, from rows 2 through 1000, allow the user to put the start of the date range in E1 and the end of the date range in E2.

Then for the total no. of success try:
=SUMIF(A2:A1000,"<="&E2,B2:B1000)-SUMIF(A2:A1000,"<"&E1,B2:B1000)

And for failures:
=SUMIF(A2:A1000,"<="&E2,C2:C1000)-SUMIF(A2:A1000,"<"&E1,C2:C1000)

Modify as needed. Hope this helps getting started.