<div>
If E2 is a date, then<br />
<br />
=IF(OR(WEEKDAY(E2)=7,WEEKD<wbr />AY(E2)=1),<wbr />2,1)
</div>


<div>
Hi,<br />
<br />
Shorter<br />
<br />
=IF(MOD(E2,7)&lt;2,2,1) <br />
<br />
Regards
</div>


<div>
<div class="content wysiwyg-content">
Can an Expert help me out with this please.<br />
<br />
I need to say<br />
<br />
IF E2 Contain either Sat or Sun, return 2 if it does not contain either return 1<br />
<br />
thanks
</div>
</div>


Can an Expert help me out with this please.

I need to say

IF E2 Contain either Sat or Sun, return 2 if it does not contain either return 1

thanks

another Excel formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.