user defined date

  • Thread starter Thread starter kaferro
  • Start date Start date
K

kaferro

I have a spreadsheet that calculates stats on a data series that starts
in 1985 and ends in 2004. Rather than always seeing the stats for the
fixed time period of 1/85-12/04, I would like to be able to enter the
start and end date and receive stats for the specified time period.
Any ideas on how to do this?
 
I think the easiest way would be to switch on AutoFilter and Filter on the
date field

Regards

Trevor
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumproduct? 1
Excel Excel 2010 take data from one spreadsheet to paste to another 1
Count Occurences of Dates Between Two Dates 0
Figuring Dates quit working! 2
Need function that will work in Excel 2003 like "Countifs" in 2007 3
Picking out a Period, in relation to certain cells 6
Period of Performance calculations 6
Excel Catagorise AM or PM 7

Back
Top