Calculating every Quarter or Half year from today

[alabatusa]

Hi All

I am trying to calculate given a varying starting day, the fall of every quarter or half year.

e.g. 1

month= 1 (Jan)
Type = quarter
Next quarter = 4 (april)

Similarly
e.g. 2
Date = 1 Feb
Type = quarter
Next quarter = 5( may)

or
Similarly
Date = 1 Feb
Type = semi annual
Next quarter = 7 (july)

Basically i need a formula given starting month to determine if the cell given falls on quarter on semi annual anniversary

such that over a calender year i would get the following for example 2.

Month	1	2	3	4	5	6	7	8	9	10	11	12
Flag	0	1	0	0	1	0	0	1	0	0	1	0

<tbody>
</tbody>

and similarly for EG 3. would return a 1 for month of Feb and July


My inputs are Month begin and quarterly/semi annual input as (3,6)

 

[iggy_]

Try something like this.

Excel 2016 (Windows) 32 bit

	A​	B​	C​	D​	E​	F​	G​	H​	I​	J​	K​	L​	M​
1​	Date	2​
2​	Type	quarter
3​	Next Quarter	5​
4​
5​	Month	1​	2​	3​	4​	5​	6​	7​	8​	9​	10​	11​	12​
6​	Flag	0​	1​	0​	0​	1​	0​	0​	1​	0​	0​	1​	0​

Sheet: Sheet11

Excel 2016 (Windows) 32 bit

	B​
3​	=IF(B2="quarter",B1+3,IF(B2="semi",B1+6,"check type"))​

Sheet: Sheet11

Excel 2016 (Windows) 32 bit

	B​
6​	=IF($B$2="quarter",IF(MOD(B$5-$B$1,3)=0,1,0),IF($B$2="semi",IF(MOD(B$5-$B$1,6)=0,1,0),"check type"))​

Sheet: Sheet11