searching between dates

  • Thread starter Thread starter Joe@Willscot
  • Start date Start date
J

Joe@Willscot

I am trying to find out how to look up data between two specific dates. i.e.
The amount of money that I have used from a specific account between 1 Jan 09
to 28 Feb 09?
 
Hi,

We could use more detail, however suppose your dates are in Column A and the
Amounts in column B. Choose Data, Filter, AutoFilter and pick the drop down
in column A. Choose Custom, choose Greater than or equal to from the first
drop down and enter 1/1/09 in the second box, choose Less than or equal to
from the second drop down and enter 2/28/09 in the next box. Click OK.

Select the first blank cell below the Amount column and click the AutoSum
button.

This will give the sum of visible cells only.
 
Thank you for responding so far.

The rest of the story: On one worksheet I have my budget for the year per
month. The budget is broken into different catagories,ie parts, minor and
major, service vehicles, gas and parts, pay, over time. The next worksheet I
have a purchase tracking page, that I log in all of my purchases or kind of
like a register with check numbers, vendors, amounts, date and this is for
the entire year. So the goal was to get the budget work sheet to show what
was spent for the month.
What I have so far is:
SUMIF(B:B,">1/1/2009",D:D) which works but I can not get it to work when I
put in <1/31/2009
 
Back
Top