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 |
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 |
All times are GMT +1. The time now is 04:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com