LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default using the WorkDay function in VBA

I have studied the MS help file for the "workday" function. However, I am
still mystified as to how one codes this function and the proper syntax.

I would like to prevent a procedure from executing if it is a weekend or
holiday.

I use Excel in Office 2007.

All suggestions or comments are very welcomed, Larry

P.S. I thank both Jim Rech and Peter T for their valuable help in a
previous question of mine regarding a "time" frame. Both suggestions worked
perfectly. I used Jim's because it was so succinct.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
WORKDAY function available? David Schwartz Excel Discussion (Misc queries) 5 April 16th 10 03:14 PM
Better Workday function. XKruodo Excel Worksheet Functions 2 April 8th 10 02:38 PM
Workday function RUSH2CROCHET Excel Discussion (Misc queries) 4 May 17th 06 07:34 PM
Workday function 4110 Excel Worksheet Functions 0 January 19th 06 03:02 PM
How do I get the WORKDAY function? jorfo Excel Discussion (Misc queries) 1 December 4th 04 11:01 PM


All times are GMT +1. The time now is 06:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"