A
Allen
I am trying to figure out an expression that will look
between dates and determine if they qualify to be
calculated for a quarter. The fun part is determining
when a date qualifies. Basically the event has to be open
for a whole month otherwise it doesn't count.
For example:
1)July 15-July 20 =0 (or not calculated)
2)July 15-Sept 15 =1 (or 1 month for that quarter)
3)July 1- Sept 30 =3 (or is open for all 3 months.
example 2(July 15- Sept 15) only equals 1 because it is
only open for the full month of Aug. The time in July and
Sept are not considered qualified.
If example 2 went from July 15th- Sept 30 it would only
then equal 2. If it went to Sept 29 it would not qualify.
Any help is appreciated.
between dates and determine if they qualify to be
calculated for a quarter. The fun part is determining
when a date qualifies. Basically the event has to be open
for a whole month otherwise it doesn't count.
For example:
1)July 15-July 20 =0 (or not calculated)
2)July 15-Sept 15 =1 (or 1 month for that quarter)
3)July 1- Sept 30 =3 (or is open for all 3 months.
example 2(July 15- Sept 15) only equals 1 because it is
only open for the full month of Aug. The time in July and
Sept are not considered qualified.
If example 2 went from July 15th- Sept 30 it would only
then equal 2. If it went to Sept 29 it would not qualify.
Any help is appreciated.