+ Reply to Thread
Results 1 to 2 of 2

Can Excel add working days to a date to result in another date?

  1. #1
    cwalrus
    Guest

    Can Excel add working days to a date to result in another date?

    For example, I need Excel to take the last day of a quarter (6/30) and add 10
    working days resulting in the date of the 10th working day.

  2. #2
    Mark Lincoln
    Guest

    Re: 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1