3rd Friday of next month

[excelbetter]

Does anyone know how to determine the date of the 3rd friday of next month, based on today's date? Meaning, if I have today's date in A1, and in B1 I want to have the date of the 3rd Friday of next month, how would I do it?

Let's assume today's date is 4/26/19

TY

 

[CalcSux78]

Excel 2010

	A	B

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]4/26/2019[/TD]
[TD="align: right"]5/17/2019[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B1[/TH]
[TD="align: left"]=(EOMONTH(A1,0)+1)+(7-WEEKDAY(EOMONTH(A1,0)+1,16))+14[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Tetra201]

A shorter one (for Excel 2010 and up):

=WORKDAY.INTL(EOMONTH(A1,0),3,"1111011")

 

[excelbetter]

A shorter one (for Excel 2010 and up):

=WORKDAY.INTL(EOMONTH(A1,0),3,"1111011")

This is great. TY

Out of curiosity, can you explain what the following is doing in the formula? I can't figure what that means.

"1111011"

 

[CalcSux78]

Smooth @Tetra201

excelbetter,

The binary looking number portion of the WORKDAY.UTIL function is the weekend portion. It's like saying count 3 days from a date, but Friday is the only Weekday.

 

[excelbetter]

Got it. TY!

Smooth @Tetra201

excelbetter,

The binary looking number portion of the WORKDAY.UTIL function is the weekend portion. It's like saying count 3 days from a date, but Friday is the only Weekday.