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

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
>
>