View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] gahagan@gmail.com is offline
external usenet poster
 
Posts: 3
Default Reverse NETWORKDAYS function?

Hi:

I know the NETWORKDAYS function will output the NET number of WORKDAYS
between a given start and finish date, skipping a given list of
holidays--but does anyone know if there's a way to input a start date,
a number of days, and a list of holidays, and get the finish date--?

For example, say I wish a task to start on 10/2, and I know it will
take me 10 workdays. How would I find the finish date if, for example,
Friday the 6th is a holiday or day off?

TIA,
AG