<div>
<pre><code id="code-20-40387079-1">=DATE(YEAR(NOW()),CHOOSE(8, MONTH(NOW()),IF(DAY(NOW())&gt;6,8,2),8,8,8,8,8,IF(DAY(NOW())&gt;6,14,8),14,14,14,14)+2,6)</code></pre>
However, if you use such a formula, you should try to understand what it does, and why.
</div>


=DATE(YEAR(NOW()),CHOOSE(8, MONTH(NOW()),IF(DAY(NOW())>6,8,2),8,8,8,8,8,IF(DAY(NOW())>6,14,8),14,14,14,14)+2,6)

However, if you use such a formula, you should try to understand what it does, and why.

<div>
Thank you. &nbsp;I used the second formula. &nbsp;Works perfectly.
</div>


Thank you.  I used the second formula.  Works perfectly.

<div>
Actually, there's an even simpler way, if you want.<br />
<br />
=COUPNCD(EDATE(TODAY(),2),<wbr />DATE(9999,<wbr />10,6),2)<br />
<br />
That will give the same results as the second formula above<br />
<br />
regards, barry
</div>


Actually, there's an even simpler way, if you want.

=COUPNCD(EDATE(TODAY(),2),DATE(9999,10,6),2)

That will give the same results as the second formula above

regards, barry

<div>
<div class="content wysiwyg-content">
experts, how can I modify the below to show a date that is 60 days after Aug 6 or Feb 6? &nbsp;The below shows a date that is 60 days after Jan15 and July 15<br />
<br />
=DATE(YEAR(NOW()),CHOOSE(M<wbr />ONTH(NOW()<wbr />),IF(DAY(N<wbr />OW())&gt;15,7<wbr />,1),7,7,7,<wbr />7,7,IF(DAY<wbr />(NOW())&gt;15<wbr />,13,7),13,<wbr />13,13,13,1<wbr />3)+2,15)<br />
<br />
<br />
thank you
</div>
</div>


experts, how can I modify the below to show a date that is 60 days after Aug 6 or Feb 6?  The below shows a date that is 60 days after Jan15 and July 15

=DATE(YEAR(NOW()),CHOOSE(MONTH(NOW()),IF(DAY(NOW())>15,7,1),7,7,7,7,7,IF(DAY(NOW())>15,13,7),13,13,13,13,13)+2,15)


thank you

Date help, within 60 days of Aug 6 and Feb 6

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