mossdrive
New Member
- Joined
- Jun 17, 2016
- Messages
- 4
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:
[TABLE="width: 246"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Q1 [/TD]
[TD="align: right"]01-Jan[/TD]
[TD="align: right"]31-Mar[/TD]
[/TR]
[TR]
[TD]Q2 [/TD]
[TD="align: right"]01-Apr[/TD]
[TD="align: right"]30-Jun[/TD]
[/TR]
[TR]
[TD]Q3 [/TD]
[TD="align: right"]01-Jul[/TD]
[TD="align: right"]30-Sep[/TD]
[/TR]
[TR]
[TD]Q4[/TD]
[TD="align: right"]01-Oct[/TD]
[TD="align: right"]31-Dec[/TD]
[/TR]
</tbody>[/TABLE]
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!
[TABLE="width: 246"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Q1 [/TD]
[TD="align: right"]01-Jan[/TD]
[TD="align: right"]31-Mar[/TD]
[/TR]
[TR]
[TD]Q2 [/TD]
[TD="align: right"]01-Apr[/TD]
[TD="align: right"]30-Jun[/TD]
[/TR]
[TR]
[TD]Q3 [/TD]
[TD="align: right"]01-Jul[/TD]
[TD="align: right"]30-Sep[/TD]
[/TR]
[TR]
[TD]Q4[/TD]
[TD="align: right"]01-Oct[/TD]
[TD="align: right"]31-Dec[/TD]
[/TR]
</tbody>[/TABLE]
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!
