Quarter Years based on Start Date

[jwb1012]

Hello everyone... I have a situation that is really puzzling with me, so I thought I would ask on the forum.

In column A, I have a list of "start dates" (ex: 1/1/2017, 5/1/2017, etc)

In row 1, I have consecutive date headers (i.e. 1/1/2017, 2/1/2017, 3/1/2017, 4/1/2017 .... )

.....................

I am trying to come up with a formula that will put a "1" to mark the "quarters" -- but not Fiscal Quarters ... I need the Quarters to be based on the start date.

When a customer opens an account, they pay for the first "quarter of the year" - then I bill them every "quarter" after that. The result I am after is shown below. The start date = 1, then every "quarter" also equals 1.

[TABLE="width: 1038"]
<tbody>[TR]
[TD][/TD]
[TD="align: right"]1/1/2017[/TD]
[TD="align: right"]2/1/2017[/TD]
[TD="align: right"]3/1/2017[/TD]
[TD="align: right"]4/1/2017[/TD]
[TD="align: right"]5/1/2017[/TD]
[TD="align: right"]6/1/2017[/TD]
[TD="align: right"]7/1/2017[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD="align: right"]9/1/2017[/TD]
[TD="align: right"]10/1/2017[/TD]
[TD="align: right"]11/1/2017[/TD]
[TD="align: right"]12/1/2017[/TD]
[/TR]
[TR]
[TD="align: right"]1/1/2017[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]5/1/2017[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody><colgroup><col><col span="11"><col></colgroup>[/TABLE]

 

[dUBBINS]

Maybe...

=IF(MONTH(K24)=MONTH(J24)+3,1,"")

 

[jwb1012]

Hi Dubbins - thank you very much for the response, but I don't think that will work for me.

 

[barry houdini]

Try this formula in B2 copied across and down as required

=IFERROR((MOD(DATEDIF($A2,B$1,"m"),3)=0)+0,0)