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.

Mar 31, 2023 in Others 271 views

## 1 answer to this question.

Try this:

```=TEXT(FILTER(SEQUENCE(DAY(EOMONTH(A4,0)),,EOMONTH(A4,-1)+1,1),WEEKDAY(SEQUENCE (DAY(EOMONTH(A4,0)),,EOMONTH(A4,-1)+1,1),1)>=6),"dd/mm/yyyy")
```

answered Mar 31, 2023 by
• 38,010 points

## Multiple find and replace in MS Word from a list in MS Excel

If I understand you correctly, you want ...READ MORE

## In Excel Sheet how to Eliminate or Remove, Filter and copy the selected records defined in another sheet using dynamic array list (VBA Module)

I'm attempting to generate an Excel sheet ...READ MORE

## What are the RGB and HEX codes of the 3 color conditional format in Excel?

In Excel 2016 at least the colors ...READ MORE

## Excel - add all X in column and then multiply

Use countif for the count then multiply ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE