View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default 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.