![]() |
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 |
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 |
All times are GMT +1. The time now is 03:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com