+ Reply to Thread
Results 1 to 3 of 3

How do I add business days to a date field, no weekends?

  1. #1
    Ozzy
    Guest

    How do I add business days to a date field, no weekends?

    I'm creating an excel spreadsheet and need to add business days only. If
    cell a1 is todays date (3/20/06), how do I make cell b1 equal a1+5 business
    days, no weekends?

  2. #2
    Niek Otten
    Guest

    Re: How do I add business days to a date field, no weekends?

    See HELP for the NETWORKDAYS function

    --
    Kind regards,

    Niek Otten

    "Ozzy" <Ozzy@discussions.microsoft.com> wrote in message news:622E15BB-D939-4678-B4A9-3C7E2C922748@microsoft.com...
    > I'm creating an excel spreadsheet and need to add business days only. If
    > cell a1 is todays date (3/20/06), how do I make cell b1 equal a1+5 business
    > days, no weekends?




  3. #3
    Ron Rosenfeld
    Guest

    Re: How do I add business days to a date field, no weekends?

    On Tue, 21 Mar 2006 13:41:28 -0800, Ozzy <Ozzy@discussions.microsoft.com>
    wrote:

    >I'm creating an excel spreadsheet and need to add business days only. If
    >cell a1 is todays date (3/20/06), how do I make cell b1 equal a1+5 business
    >days, no weekends?



    =WORKDAY(A1,5)

    Check HELP for the WORKDAY function. There is an optional Holidays argument.
    If you get a NAME error, you need to install the Analysis Tool Pak. This is
    outlined in the HELP topic for the WORKDAY function.
    --ron

+ 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