Thread: Can Excel add working days to a date to result in another date?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark Lincoln
 
Posts: n/a
Default Can Excel add working days to a date to result in another date?
Use the WORKDAY function. These examples are from the Excel 97 help
entry for WORKDAY:

WORKDAY(DATEVALUE("01/03/91"), 5) equals 33248 or 01/10/91

If January 7, 1991 and January 8, 1991 are holidays, then:
WORKDAY(DATEVALUE("01/03/91"), 5, {33245, 33246}) equals 33252
or 01/14/91

Reply With QuoteReply With Quote