Thread: Reverse NETWORKDAYS function?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Reverse NETWORKDAYS function?
=workday()
???

wrote:

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

--

Dave Peterson
Reply With QuoteReply With Quote