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
1	4/26/2019	5/17/2019

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula B1 =(EOMONTH(A1,0)+1)+(7-WEEKDAY(EOMONTH(A1,0)+1,16))+14 <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[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.