doctortt
12-04-2012, 02:35 PM
Hi, I'm sure there is another way to do this. Can a guru shed some light?
M2: June 30, 2013
M3: July 31, 2013
N2: July 31, 2013
N3: August 31, 2013
O2: August 31, 2013
O3: September 30, 2013
Assumptions!$E$8: 3 (in Months)
I get a flag of 1 using the codes below because on September 30, 2013, it's a quarter.
=1*OR(AND(NOT(MOD(MONTH(O3),3)=0),O11=Assumptions!$E$8),AND(MOD(MONTH(O3),3 )=0,NOT(O11=Assumptions!$E$8)))
M2: June 30, 2013
M3: July 31, 2013
N2: July 31, 2013
N3: August 31, 2013
O2: August 31, 2013
O3: September 30, 2013
Assumptions!$E$8: 3 (in Months)
I get a flag of 1 using the codes below because on September 30, 2013, it's a quarter.
=1*OR(AND(NOT(MOD(MONTH(O3),3)=0),O11=Assumptions!$E$8),AND(MOD(MONTH(O3),3 )=0,NOT(O11=Assumptions!$E$8)))