<div>
How about this? &nbsp;My join date starts in A2 and my column headings start in B1.<br />
<br />
=IF(SUMPRODUCT(--(OFFSET(I<wbr />1,0,-6,1,6<wbr />)&gt;$A$2))=6<wbr />,1,&quot;&quot;)<br />
<br />
Kyle
</div>


How about this?  My join date starts in A2 and my column headings start in B1.

=IF(SUMPRODUCT(--(OFFSET(I1,0,-6,1,6)>$A$2))=6,1,"")

Kyle

Month-differenceQ27646260.xlsx

<div>
<div class="content wysiwyg-content">
Hey experts,<br />
<br />
I have a Excel like:<br />
<br />
join date &nbsp; &nbsp; &nbsp;Jan 2009 &nbsp;Feb 2009 ........Mar 2012<br />
2008/1/5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1<br />
2010/4/10 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1<br />
<br />
formula inside =if(or(month(a2)&lt;=month(b2<wbr />), year(a2)&lt;year(b2)),1,&quot;&quot;)<br />
<br />
that is, if the column heading date is larger than join date, 1 will be shown. and it works well<br />
<br />
now I would like in another worksheet in same setting to set if the column heading date &gt;&nbsp;join date for 6 months, 1 will be shown, else is &quot;&quot;<br />
<br />
I try many times but fail........help..........<wbr />.........
</div>
</div>


Hey experts,

I have a Excel like:

join date      Jan 2009  Feb 2009 ........Mar 2012
2008/1/5          1               1                           1
2010/4/10                                                      1

formula inside =if(or(month(a2)<=month(b2), year(a2)<year(b2)),1,"")

that is, if the column heading date is larger than join date, 1 will be shown. and it works well

now I would like in another worksheet in same setting to set if the column heading date > join date for 6 months, 1 will be shown, else is ""

I try many times but fail........help...................

Excel counting month difference

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.