# Date Formula Request

#### dbsbender

##### New Member

I am trying to calculate the "3rd Thursday of next quarter". Going forward, I'd like to be able to calculate the "nth" day of "nth" quarter, year. (to return a date).

I'd prefer not to use VBA if possible, this will be used by multiple level excel users.

### Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Try these:

 A B C D 1 nth Day nth Quarter Year Date 2 2 4 2014 02/10/2014

<tbody>
</tbody>

A2, B2, C2 are user inputs

D2: =DATE(C2,LOOKUP(B2,{1,2,3,4},{1,4,7,10}),1)+A2-1

 A B C 4 Date First Day Next Quarter 3rd Thursday 5 10/01/2014 01/04/2014 17/04/2014

<tbody>
</tbody>

A5 is user input

B5 (helper column): =IF(MONTH(A5)>9,DATE(YEAR(A5)+1,LOOKUP(MONTH(A5),{1,2,3,4,5,6,7,8,9,10,11,12},{4,4,4,7,7,7,10,10,10,1,1,1}),1),DATE(YEAR(A5),LOOKUP(MONTH(A5),{1,2,3,4,5,6,7,8,9,10,11,12},{4,4,4,7,7,7,10,10,10,1,1,1}),1))

C5: =B5-DAY(B5)+22-WEEKDAY(B5-DAY(B5)+3)

I am so very grateful - thank you!

1st 4 are user inputs 4th is equation =("Day of Week"-WEEKDAY(DATE("Year",1,1))+DATE("Year",1,1)+(("Quarter"-1)*13+"Day of Quarter")*7)
 Year 2014 Day Of Week 5 Day of Qtr 3 Quarter 3 Date 7/24/2014

<tbody>
</tbody>

Replies
8
Views
709
Replies
7
Views
554
Replies
0
Views
425
Replies
6
Views
390
Replies
7
Views
556

1,217,753
Messages
6,138,417
Members
450,135
Latest member
IsidroGil

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back