Formulas to calculate Recurring Dates?

[slam]

I have 23 recurring tasks I am trying to calculate the dates for over the next several years. Their recurrence pattern is not always straight forward, and some can't even be defined with Microsoft Outlook recurrence options.

I have dates listed in A2 and down, and one task per column in B onward. I am trying to have a Y displayed on the recurrence instance within that column.

I've done some weird shortcuts or manual work to figure out a lot of these, but I think if I can get help with these 3, I can figure out the rest. Can these be calculated via formula?

• Y for first Tuesday of a Month where day before, Monday, is in same calendar Month
• Y for 1st of each Month, unless the 1st is a Saturday, in which case Y for last day of previous month, or if 1st is a Sunday Y for the 2nd.
• Y for 5th, or the next weekday after the 5th (6th or 7th)

 

[Dave Patton]

try

T202209a.xlsm
	A	B	C	D	E	F	G	H	I
2	23-Sep-22	Tue 06-Sep-22	First Tuesday of Month and Monday is in same month
3
4	31-Aug-22	Thu 01-Sep-22	1st of each Month, unless the 1st is a Saturday, in which case Y for last day of previous month, or if 1st is a Sunday Y for the 2nd.
5
6	5-Sep-22	Mon 05-Sep-22	for 5th, or the next weekday after the 5th (6th or 7th)
7
6d

Cell Formulas
Range	Formula
A2	A2	=TODAY()
B2	B2	=WORKDAY.INTL(EOMONTH(A2,-1),1,"0111111")+1
B4	B4	=IF(WORKDAY.INTL(A4,1,"1111101")<>1,A4+1,A4)
B6	B6	=WORKDAY.INTL(A6-1,1,1)

 

[Dave Patton]

A post to edit one of the formulas does not show.
Please post a few examples of your question and expected results.
N.B. You can post an extract of your sheet with the forum's tool named XL2BB.

 

[Dave Patton]

"Please post a few examples of your question and expected results." No examples or reply was posted.

T202209a.xlsm
	A	B	C	D
1	Year	Month
2	2022	Sep	Tue 06-Sep-22	First Tuesday of Month and Monday is in same month
3
4	2022	Aug	Mon 01-Aug-22	1st of each Month, unless the 1st is a Saturday, in which case Y for last day of previous month, or if 1st is a Sunday Y for the 2nd.
5	2022	Sep	Thu 01-Sep-22	1st of each Month, unless the 1st is a Saturday, in which case Y for last day of previous month, or if 1st is a Sunday Y for the 2nd.
6	2022	Oct	Fri 30-Sep-22	1st of each Month, unless the 1st is a Saturday, in which case Y for last day of previous month, or if 1st is a Sunday Y for the 2nd.
7
8	2022	Sep	Mon 05-Sep-22	for 5th, or the next weekday after the 5th (6th or 7th)
9
6d

Cell Formulas
Range	Formula
C2	C2	=WORKDAY.INTL(DATE(A2,MONTH(1&B2),0),1,"0111111")+1
C4:C6	C4	=LET(x,WORKDAY.INTL(DATE(A4,MONTH(1&B4),0),1,1),IF(DAY(x)=3,x-3,x))
C8	C8	=WORKDAY.INTL(DATE(A8,MONTH(1&B8),4),1,1)