View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lwchapman lwchapman is offline
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.