3rd Friday of next month

excelbetter

Board Regular
Joined
Oct 13, 2010
Messages
178
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
Joined
Oct 15, 2013
Messages
1,120
Excel 2010
AB
14/26/20195/17/2019

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

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

<thead>
</thead><tbody>
</tbody>

<tbody>
</tbody>
 

excelbetter

Board Regular
Joined
Oct 13, 2010
Messages
178
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
Joined
Oct 15, 2013
Messages
1,120
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.
 

Forum statistics

Threads
1,082,589
Messages
5,366,494
Members
400,895
Latest member
Anthonemr

Some videos you may like

This Week's Hot Topics

Top