Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Netherlands
    Posts
    158
    Thanks
    2
    Thanked 0 Times in 0 Posts

    To calculate or not to calculate

    This is my problem. In column H is a date and in column O is a date. I can easily count the number of workdays between them using the net.workdays function. So far so good.

    In column N is a fixed value, either a 0 or a 1. If N=0, then I do not need to do any calculation. If N=1 then I need to calculate the number of workdays between H and O.

    So whether I do a calculation or not depends on the value in N. If it is 0, then I would like to have a blank cell. If it is 1, then the calculated numer of workdays.

    How can I best go about doing this?

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi Maury

    What you need is:
    =IF(N2=0,"",NETWORKDAYS(H2,O2))

    ..if your start date is in cell [H2] and your end date is in cell [O2]

    zeddy

  3. #3
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Netherlands
    Posts
    158
    Thanks
    2
    Thanked 0 Times in 0 Posts
    SUPER!! Thanks a lot.

    Thread closed.

Posting Permissions

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