D
Darrell_Sarrasin via OfficeKB.com
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.
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.