# 3rd Friday of next month

#### excelbetter

##### Board Regular
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

##### Well-known Member
Excel 2010
AB
14/26/20195/17/2019

</tbody>
Sheet1

Worksheet Formulas
CellFormula
B1=(EOMONTH(A1,0)+1)+(7-WEEKDAY(EOMONTH(A1,0)+1,16))+14

</tbody>

<tbody>
</tbody>

#### Tetra201

##### MrExcel MVP
A shorter one (for Excel 2010 and up):

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

#### excelbetter

##### Board Regular
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

##### Well-known Member
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

##### Board Regular
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.