get next quarter date , third friday

[daveyc18]

hi,

i'm trying to make a formula so that the next quarter, third friday is shown....(ie December 21)

 

[daveyc18]

hi,

i'm trying to make a formula so that the next quarter, third friday is shown....(ie December 21)

sorry scratch that...the first day of the NEXT quarter (e.g., december 1)

 

[Rick Rothstein]

hi,

i'm trying to make a formula so that the next quarter, third friday is shown....(ie December 21)

December 1st starts your quarter? So your quarters start on December 1st, March 1st, June 1st, September 1st... is that correct?

 

[Rick Rothstein]

It is an ugly formula, but I think it will return the dates you want...

=DATE(YEAR(LOOKUP(TODAY(),DATE(YEAR(TODAY()),{1,3,6,9,12;3,6,9,12,15},1))),MONTH(LOOKUP(TODAY(),DATE(YEAR(TODAY()),{1,3,6,9,12;3,6,9,12,15},1))),22)-WEEKDAY(DATE(YEAR(LOOKUP(TODAY(),DATE(YEAR(TODAY()),{1,3,6,9,12;3,6,9,12,15},1))),MONTH(LOOKUP(TODAY(),DATE(YEAR(TODAY()),{1,3,6,9,12;3,6,9,12,15},1))),2))

 

[Dave Patton]

Your question is not clear.
A few examples might help.

Consider the following.
The dates for the lookup can be in a range of cells or built into the formula.

Excel 2010
	A	B	C	D	E	F
1	Date	Next Qtr	Next Qtr	3rd Friday		1-Sep-18
2	22-Oct-18	1-Dec-18	1-Dec-18	21-Dec-18		1-Dec-18
3						1-Mar-19
1b

Cell Formulas
Range	Formula
B2	=EDATE(LOOKUP(A2,$F$1:$F$9),3)
C2	=EDATE(LOOKUP(A2,{43344;43435;43525;43617;43709;43800;43891;43983;44075}),3)
D2	=C2+7-WEEKDAY(DATE(YEAR(C2),MONTH(C2),8-6))+14

 

[Tetra201]

It is an ugly formula, but I think it will return the dates you want...

Just for fun -- here is a more compact formula that returns the same results:

=WORKDAY.INTL(EDATE(EOMONTH(TODAY(),-1)+1,CEILING(MONTH(TODAY())+1,3)-MONTH(TODAY()))-1,3,"1111011")