Determine Date Quarter

[Tarball]

Given the following following fiscal year intervals:

The dates are set via calendar control but would be static through the fiscal year.
Q1= 9/27/2009 - 12/26/2009
Q2=12/27/2009 - 3/27/2010
Q3=3/28/2010 - 6/28/2010
Q4=6/27/2010 - 9/26/2010

Given input as a date (either before the interval above, inside the interval, or outside of the interval), I need to determine what Quarter the input date would fall into.

Example:
Given 03/31/2007 I need to return Q2 2007 (2007 fiscal year)
Given 09/28/2006 I need to return Q1 2007 (2007 fiscal year)

Given 9/27/2009 I need to return Q1 2009

Any ideas how I can do this in VBA?

[tony h]

The attached sheet shows the dates in a table.

The coloured columns are formulas to pull back any of the information

Note it actually only tests on start date. The assumption is that the start date of one period is the day after the close of another period.

[Tarball]

Thanks so much. You have given me several new ideas. I was stuck. I really appreciate the help.