| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Age old business day with holiday entry
Hi everyone.
basically what I am trying to do is I have to create a form that takes an entered date and calculates a certain time period ahead. example is that if I enter todays date 12/13/2007 I need something that will calculate 10 business days ahead and exclude christmas as its a holiday. My main issue thou is that I can not install any plug ins as this is a business computer that is locked down. I did try the code that was posted in 2006, the one that reads as =WORKDAY(WORKDAY(A1,-1,J$1:J$10),5,J$1:J$10 but it does not do anything on my sheet. thanks. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200712/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Where can I get a good holiday booking form for my golf business? | Excel Discussion (Misc queries) | |||
| Calculating 10 Business Days from the Last Business Day of the Mon | Excel Worksheet Functions | |||
| how do I add words, holiday =1, holiday am=0.5 | Excel Worksheet Functions | |||
| Holiday Planner show holiday taken? | Excel Worksheet Functions | |||
| WHERE CAN I GET A BUSINESS PROPOSAL OR A BUSINESS EXPENSE SHEET? | New Users to Excel | |||
Threaded Mode
