show day of the month

[chriswrcg]

I am looking for a formula that will let me show a particular day of the month. Specifically lets say I want to show the 3rd Monday of October 2017, or the second Friday of August 2016.
I would also like the formula to look to a cell for the month so that if I change from October to November all the date cells will auto shift to the new date.
Below is an example of what I am talking about.

[jeffreybrown]

Maybe this will help...

http://dmcritchie.mvps.org/excel/datetime.htm

[Phuocam]

Try this:

=WORKDAY.INTL((1&A$1&B$1)-1,3,"0111111")

...

[Root_]

Here is a formula:

=WORKDAY.INTL(($A$1&B$1)-1,LEFT($A$3),LEFT(REPT(1,MATCH($B$3,TEXT({2,3,4,5,6,7,8},"dddd"),0)-1)&"0111111",7))

Take a look at the attached file.

[Richard Buttrey]

Here's one generalised option

A1: 1st of the month in question. e.g. November 1 2017
A2: Day required. Monday - 1, Tuesday = 2......Sunday = 7
A3: 1st, 2nd, 3rd, 4th occurrence of A2 day. Enter 1,2,3 or 4

Formula

Please Login or Register  to view this content.