Excel 2007 : Find bank balance in bank statement

Dear Experts,

is there any formula to get the balance of a bank statement for a particular date
if there the more than one entry in the date
in attached sheet i want to know the balance of bank statement in cell "B1" by entring the date in cell "A1"

The attached file includes an added helper column H and alternate lookup formula in cell B1.

Try this formula in cell B1:

Formula:

Please Login or Register  to view this content.

This is working good, but not working for if date was not available in excel
like, i want to know the balance on 20/04/2012 and it should be 1,00,582.46

You're welcome. And thanks for the 'star tap'.