First day of each week in a quarter

[mossdrive]

I am looking for some help on creating a formula that will return the first day of each week in a quarter based on the current year and eliminating holidays. Each returned value would be populated in the header of each column. Quarters are as follows:

Q1	01-Jan	31-Mar
Q2	01-Apr	30-Jun
Q3	01-Jul	30-Sep
Q4	01-Oct	31-Dec

<colgroup><col><col><col></colgroup><tbody>
</tbody>

I am not really sure where to start with this so I don't have an example formula to share at this point.
Thanks very much!

 

[Joe4]

Take a look at the WORKDAY function: https://www.techonthenet.com/excel/formulas/workday.php

 

[mossdrive]

OK, I have been playing with this and I think I'm almost there.

=WORKDAY(EOMONTH(DATE(E3,1,1),-1),1) gives me the first day of the current year where E3 contains the current year
=WORKDAY(EOMONTH(G3,2),-1) gives me the last day of the third month (Q1)
=WORKDAY(EOMONTH($G$3,-1), 1,DATEDATA!$B$10:$B19) gives me the first "workday" after the first day of the year excluding holidays which are contained on a different sheet at $B$10:$B19

This all works how I want it. Where I am stuck is getting the first day of each subsequent week after the first workday excluding the holidays I have defined. I have tried =WORKDAY(EOMONTH($G$3,-1), 5,DATEDATA!$B$10:$B19) incrementing the number of days by 5 but this doesn't work as it doesn't account for any missing days this way due to holidays. glad of any assistance
Thanks in advance!

 

[mossdrive]

Wondering if anyone has ideas on the question above, or am I missing some information needed in order to give an answer? Thanks!

 

[Fluff]

Cross posted https://www.excelguru.ca/forums/sho...day-of-each-week-in-a-year-excluding-holidays

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.