Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Help with Formula (2000 sp3)

    All,
    I have a formula where I am using the function NETWORKDAYS.
    =IF(NETWORKDAYS(G2,X2,Calendar!$E$1:$E$207)<0,"",N ETWORKDAYS(G2,X2,Calendar!$E$1:$E$207)).

    Where I am looking at the tab Calendar for the range of days off. This all works correctly, however in the instance where the comparison between the two dates is of the same day, I am getting a return of zero for the count of days. Is it possible to have this formula indicate that this is equal to one (1) day instead of zero?

    Thanks,
    Brad

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Help with Formula (2000 sp3)

    How about:
    =IF(NETWORKDAYS(G2,X2,Calendar!$E$1:$E$207)<0,"",I F(NETWORKDAYS(G2,X2,Calendar!$E$1:$E$207)=0,1,NETW ORKDAYS(G2,X2,Calendar!$E$1:$E$207)))

    or perhaps:
    =IF(NETWORKDAYS(G2,X2,Calendar!$E$1:$E$207)<0,"",1 +NETWORKDAYS(G2,X2,Calendar!$E$1:$E$207))

    If you want to shift all by 1 day.

    Steve

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help with Formula (2000 sp3)

    Steve,

    Works Great!

    Thanks,
    Brad

Posting Permissions

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