I have a list of date for the complete month generated by the formula =IF(ROWS($A$10:A10)>DAY(B$5),"",$B$4+ROWS(A$10:$A10)-1) where B4 is the start date and B5 is the end date I got the list of dates but I want to exclude the weekend Saturday and Sunday from the List.
Please Help me to sort out this issue.
If one has Office 365 put this in the first cell:
=WORKDAY.INTL(B4-1,SEQUENCE(NETWORKDAYS.INTL(B4,B5)))
And it will spill the results.
If not then put this in the first cell and copy down:
=IF(ROW($ZZ1)>NETWORKDAYS.INTL($B$4,$B$5),"",WORKDAY.INTL($B$4-1,ROW($ZZ1)))