| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Formula
I need to figure out a formula that returns a date, for exmaple I need to
determine the date 10 bussines days from now taking into account a determined list holidays...can you help me out with this?..I have tried networkdays but can't figure it out.....thanks for your help |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Formula
Hi,
Try this =WORKDAY(TODAY(),10,Holidays) Where holidays is a named range of cells that contain the sates of holidays to exclude Mike "jcheko" wrote: I need to figure out a formula that returns a date, for exmaple I need to determine the date 10 bussines days from now taking into account a determined list holidays...can you help me out with this?..I have tried networkdays but can't figure it out.....thanks for your help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
| Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
| Date formula: return Quarter and Fiscal Year of a date | Excel Discussion (Misc queries) | |||
Linear Mode
