business day date from a specific date based on a number of days
 

Need a formula that will give me a business day date from a specific date
based upon number of days. For example: from 3/31/08 (an implementation
date) I need to find what my Code Start Date is which should be 30 days prior
to 3/31/08
Any help you can give me would be appreciated.

business day date from a specific date based on a number of days
 

=WorkDay(the_date,-30)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Jana" wrote in message
...
Need a formula that will give me a business day date from a specific date
based upon number of days. For example: from 3/31/08 (an implementation
date) I need to find what my Code Start Date is which should be 30 days
prior
to 3/31/08
Any help you can give me would be appreciated.

business day date from a specific date based on a number of da
 

just to remember, workday functiopn needs the Analysis ToolPak Add-in installed

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Bob Phillips" escreveu:

=WorkDay(the_date,-30)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Jana" wrote in message
...
Need a formula that will give me a business day date from a specific date
based upon number of days. For example: from 3/31/08 (an implementation
date) I need to find what my Code Start Date is which should be 30 days
prior
to 3/31/08
Any help you can give me would be appreciated.