Selecting Specific Data By Dates

Originally Posted by GeneralDisarray

I don't see any functions in the Excel file you attached.

But, if you are looking to find the Quarter for a given date, you could use the 'Choose' and 'Month' functions:

=CHOOSE(MONTH(Cell_With_Date_Value),"Q1","Q1","Q1","Q2","Q2","Q2","Q3","Q3","Q3","Q4","Q4","Q4")

Basically, that would assign a value like Q1 to any date from Jan,Feb,Mar etc. Could add a column for quarter and then use that in your function somehow?

Thanks i'll give it a try!