The date 2023-03-01 is in cell K6, and I've entered the Friday formula in cell E11 using Excel formulae.
=IF(MONTH($K$6-MOD(WEEKDAY($K$6,1)-6,7)+IF(WEEKDAY($K$6,1)<6,7,0)+7*(INT((ROW()-11)/2)))=MONTH($K$6),$K$6-MOD(WEEKDAY($K$6,1)-6,7)+IF(WEEKDAY($K$6,1)<6,7,0)+7*(INT((ROW()-11)/2)),"")
And in cell E12, I put the following formula for Saturdays
=IF(MONTH($K$6-MOD(WEEKDAY($K$6,1)-7,7)+IF(WEEKDAY($K$6,1)<7,7,0)+7*(INT((ROW()-11)/2)))=MONTH($K$6),$K$6-MOD(WEEKDAY($K$6,1)-7,7)+IF(WEEKDAY($K$6,1)<7,7,0)+7*(INT((ROW()-11)/2)),"")
Also, the formulae correctly calculate the date 2023-03-01 in cell K6.
Nevertheless, when I changed the date in cell K6 to April 1, 2023, I received an empty return in E11 because the month began on a Saturday. Is it feasible to modify the formula so that cell E12 or E12 does not produce an empty result?
I can adjust the formula in E11 to work with both Fridays and Saturdays
=IF(MONTH($K$6-MOD(WEEKDAY($K$6,1)-6-IF(WEEKDAY(DATE(YEAR($K$6),MONTH($K$6),1),1)=7,1,0),7)+IF(WEEKDAY($K$6,1)<6,7,0)+7*(INT((ROW()-11)/2)))=MONTH($K$6),$K$6-MOD(WEEKDAY($K$6,1)-6-IF(WEEKDAY(DATE(YEAR($K$6),MONTH($K$6),1),1)=7,1,0),7)+IF(WEEKDAY($K$6,1)<6,7,0)+7*(INT((ROW()-11)/2)),"")
But as for cell E12 is not adjusted.
This is my try in cell E12
=IFERROR(IF(MONTH($K$6-MOD(WEEKDAY($K$6,1)-IF(ISNUMBER(E11),7,6)-IF(WEEKDAY(DATE(YEAR($K$6),MONTH($K$6),1),1)=7,1,0),7)+IF(WEEKDAY($K$6,1)<IF(ISNUMBER(E11),7,6),IF(ISNUMBER(E11),7,6)+1,IF(ISNUMBER(E11),7,6))+7*(INT((ROW()-11)/2)))=MONTH($K$6),$K$6-MOD(WEEKDAY($K$6,1)-IF(ISNUMBER(E11),7,6)-IF(WEEKDAY(DATE(YEAR($K$6),MONTH($K$6),1),1)=7,1,0),7)+IF(WEEKDAY($K$6,1)<IF(ISNUMBER(E11),7,6),IF(ISNUMBER(E11),7,6)+1,IF(ISNUMBER(E11),7,6))+7*(INT((ROW()-11)/2)),""),"")
But not accurate in results.
