<div>
Hi, Andy.<br />
<br />
Use a nested IIF. &nbsp;Something like this<br />
<br />
IIf(Weekday(Date) &lt;&gt;&nbsp;vbSaturday And Weekday(Date) &lt;&gt;&nbsp;vbSunday,Code_for_Weekdays<wbr />, Code_for_Weekends)
</div>


Hi, Andy.

Use a nested IIF.  Something like this

IIf(Weekday(Date) <> vbSaturday And Weekday(Date) <> vbSunday,Code_for_Weekdays, Code_for_Weekends)

<div>
Hi BlueDevil fan,<br />
<br />
Still not clear how this would exclude the weekends from the date calculation<br />
<br />
Andy
</div>


Hi BlueDevil fan,

Still not clear how this would exclude the weekends from the date calculation

Andy

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have created a custom form based on Contacts in Outlook 2003. It has 2 fileds, a rexceived and responded date/time. I want to calculate the lapsed time in hours but I want to EXCLUDE weekends and bank holidays. The formula below is fine to calculate the elapsed house but how would I exclude weekends/holidays Thnks very musc. Andy<br />
<br />
IIf(DateDiff(&quot;h&quot;,[Date Received],[Respond Date])&lt;0,&quot;In Progress&quot;,DateDiff(&quot;h&quot;,[Da<wbr />te Received],[Respond Date]))
</div>
</div>


Hi,

I have created a custom form based on Contacts in Outlook 2003. It has 2 fileds, a rexceived and responded date/time. I want to calculate the lapsed time in hours but I want to EXCLUDE weekends and bank holidays. The formula below is fine to calculate the elapsed house but how would I exclude weekends/holidays Thnks very musc. Andy

IIf(DateDiff("h",[Date Received],[Respond Date])<0,"In Progress",DateDiff("h",[Date Received],[Respond Date]))

Outlook Custom Forms - date calculation

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.