<div>
Hi,<br />
<br />
pls try<br />
<br />
=WORKDAY(DATE(YEAR(H865),M<wbr />ONTH(H865)<wbr />,14),1,Hol<wbr />idays_US_J<wbr />ap)<br />
<br />
Regards
</div>


Hi,

pls try

=WORKDAY(DATE(YEAR(H865),MONTH(H865),14),1,Holidays_US_Jap)

Regards

<div>
Hi, I dont think that is the solution. &nbsp;If you drag that formula down, the date repeats and doesnt change to the next month. <br />
<br />
Follow me? <br />
<br />
thank you
</div>


Hi, I dont think that is the solution.  If you drag that formula down, the date repeats and doesnt change to the next month.

Follow me?

thank you

<div>
<div class="content wysiwyg-content">
Experts, I need a formula I can drag down that will give me the 15th of every month and use the following (not preceding) day if the 15 lands on a holiday or a weekend. &nbsp;It would be something similar to the below but this addes 15 workdays to a date. &nbsp;<br />
<br />
=WORKDAY(EOMONTH(H865,MOD(<wbr />12-MONTH(H<wbr />865),1)),1<wbr />5,Holidays<wbr />_US_Jap)<br />
<br />
thank you
</div>
</div>


Experts, I need a formula I can drag down that will give me the 15th of every month and use the following (not preceding) day if the 15 lands on a holiday or a weekend.  It would be something similar to the below but this addes 15 workdays to a date.  

=WORKDAY(EOMONTH(H865,MOD(12-MONTH(H865),1)),15,Holidays_US_Jap)

thank you

The 15th of every month and use following workday

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