Date calculation

  • Thread starter Thread starter Brett
  • Start date Start date
B

Brett

I'm trying to create a simple formula without using VB to calculate 3
days from the current date counting weekdays only. Does anyone have a
simple formula?

Thanks,

Brett
 
It is not possible to make this calculation with a simple formula, at least not one that you can debug easily. The simplest I've been able to devise is posted at http://www.outlookcode.com/codedetail.aspx?id=153. I also have a comprehensive NextBusinessDay2() function in my book, whose sample code you can download from the 'get the code' button at URL below. Take a look at listing 14.4.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
 
Back
Top