I currently use this formula which skips all sundays dates however I would now like to skip Saturdays and Sundays from a returned value however I cannot seem to figure it out? Here is the formula we currently have:
=IF(M2="","",IF(Sheet1!G5=Sheet2!D1,Sheet2!D1,IF(Sheet2!B1="1",M2,M2+IF(OR(Sheet2!B1={"2","3","4"}),1+(WEEKDAY(M2)=7)))))
Thank you in advance for any assistance you can provide.