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

J

Jana

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

Bob Phillips

=WorkDay(the_date,-30)

--
HTH

Bob

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

Marcelo

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Calculating the end date? 7
If a date range contains a leap year (date) 14
Exclude weekends when counting days only on day 29 or 30 3
Lookup between two dates 3
Dates - Need to display date one month prior to user-entered date 13
I need Help with a date calculator 0
count days from a one date to another date 11

Top