View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
XKruodo XKruodo is offline
external usenet poster
 
Posts: 16
Default Better Workday function.

Hi,
Few days back i posted this.

http://www.microsoft.com/office/comm...sloc=en-us&p=1

I couldn't make the UDF work. So i used Pearson's better workday function.
I used the example workboook and yes, that's what i was looking for.
Now how do i use it for multiple dates?

My sheet contains dates in colunm A.

1. How do i get due dates in Column B?
2. Do i need to make 2 sheets, one for MWF batch and another for TTS batch?
3. My list of holidays is entire H column. Pearson's sheet gives only about
10 holidays..
4. I have office 2007. So please suggest functions that work with 2007.

TIA.