"Which Excel function for a date range?" Topic

We have a spreadsheet at work that has info with dates in one column, and a destination in the next.

Is there a function where I can enter start and end dates, and the searched-for location, and return how many times that location appears in that date range?

I'm not sure about a date range, but "count" function can be used to count the number of instances for a particular date. I have a spreadsheet that does that at work, I'll send you the formula when I get in tomorrow.

You would still have to combine this with an "IF" statement if you have too many choices.

I set the cell properties to "Text."

Last Hussar, if you don't want to automate it, just use a filter for a date range first, then another filter for the location.

Hope that helps. Excel is a very poor tool for data – awesome of course for spreadsheet calculations. My opinion of course!
--
Tim

this is from a multi-tab worksheet that I used to track small component completions as part of a larger project.

=COUNTIF(Simple!D$3:D$188,A127)

"simple" – tab with info

"D3:D188" – range of data looked at. looking for dates components were finished.

"A127" – date of completion I'm looking for.

As I use inter connected tabs, it allows me to enter data on only one tab with all subsequent tabs updated automatically. The formala allows for the automatic tracking of when components were finished that then fed into a graph showing percentage of work completed.

Hope this helps.

Thanks for trying guys, but unfortunately I know all of these.