get the 12th date

[daveyc18]

not sure if this is possible, but I'm trying to get the 12th day ..but if the 12th day falls on a weekend , I want the tuesday following

e.g., this month (July)...July 12th is fine because it falls on a Friday


but, for May....the 12th was on a Sunday, so I want the formula to pick up May 14, Tuesday.

another example is January....12th was on a Saturday, so I want formula to pick up January 15 , Tuesday


What's the reference point? It doesn't matter to me (e.g., absed on today's date, end of month date, working end of month date, etc.)....whatever is easiest I guess!

 

[SpillerBD]

WORKDAY is the function to go with, or at least start with.
Are you also excluding Mondays?

 

[daveyc18]

WORKDAY is the function to go with, or at least start with.
Are you also excluding Mondays?

it's just the policy

 

[SpillerBD]

What is the policy?

 

[daveyc18]

What is the policy?

excludijg Mondays

 

[SpillerBD]

Aug 12 is a Monday. It is not a Weekend. So you want Monday, August 12th?

 

[Aryatect]

Hi, Assuming from @SpillerBD's post #6 that if for Aug 12 you want Monday only, then below can be 1 option:

Book1
	A	B	C
1	7/1/2019	7/12/2019	Friday
2	8/1/2019	8/12/2019	Monday
3	9/1/2019	9/12/2019	Thursday
4	10/1/2019	10/15/2019	Tuesday
5	11/1/2019	11/12/2019	Tuesday
6	12/1/2019	12/12/2019	Thursday
7	1/1/2020	1/12/2020	Sunday
Sheet3

Cell Formulas
Range	Formula
B1	=IF(WEEKDAY(A1+11,2)={6,7},A1+11+3,A1+11)

 

[Dave Patton]

Try the following

Excel 2010
	A	C
1	01-Jul-19	Fri 12-Jul-19
2	01-Aug-19	Tue 13-Aug-19
3	01-Sep-19	Thu 12-Sep-19
4	01-Oct-19	Tue 15-Oct-19
5	01-Nov-19	Tue 12-Nov-19
6	01-Dec-19	Thu 12-Dec-19
7	01-Jan-20	Tue 14-Jan-20
8
1c

Cell Formulas
Range	Formula
C1	=WORKDAY.INTL(A1+10,1,"1000011")