Question regarding date formulas to exclude a weekend as a returned value.

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.

March 31st, 2015 9:21pm

Does this do what you want?

=IF(M2="","",IF(Sheet1!G5=Sheet2!D1,Sheet2!D1,WORKDAY(M2,IF(Sheet2!B1="1",0,1))))

Free Windows Admin Tool Kit Click here and download it now
April 1st, 2015 1:52am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics