List of information Between 2 Dates

[JWM]

HI Guys

Im new here so I hope you can help me.


I have a list of reciepts for this tax year. But I sometime need to know the total of my list between two specific dates.

What I would like to do is be able to have 2 boxes in which I can put dates.

For example between 12/03/2012 and 12/04/2012

Then have the formula total only the information in the list between those dates.

Without damaging the original data sheet as well.


My workbook is in 3 pages.

First sheet has the date, starting with the date and ending with the amount.

The second sheet is my income and Ill need the formula to work here too.

The third sheet is where I need the information to go.


Hope you can help

 

[Faseeh]

Hi JWM,


Welcome to the Chandoo's Forum! I have worked out a sheet containing fictitious data for your problem. Kindly checkout this file:


http://dl.dropbox.com/u/60644346/Sales_Income.xlsx


Thanks,

Faseeh