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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Age old business day with holiday entry
If A1 contains 12/13/2007 and J$1:J$10 includes 12/25/2007 and 12/26/2007 then
WORKDAY(A1,10,J$1:J$10) shall return 12/31/2007. Regards, Stefi €˛Darrell_Sarrasin via OfficeKB.com€¯ ezt Ć*rta: 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 |
Reply |
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 |