| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding business days to a date | Excel Worksheet Functions | |||
| Want to calculate 3 business days from a certain existing date | Excel Discussion (Misc queries) | |||
| How do I set up alarms based on days from a specific date? | Excel Worksheet Functions | |||
| business days - trade date plus 3 | Excel Worksheet Functions | |||
| business days between 2 date feilds | Excel Worksheet Functions | |||
Linear Mode
