Results 1 to 4 of 4

Network Days Formula Help

Threaded View

robertguy Network Days Formula Help 05-31-2013, 05:17 AM
:) Sixthsense :) Re: Network Days Formula Help 05-31-2013, 05:19 AM
robertguy Re: Network Days Formula Help 05-31-2013, 05:25 AM
:) Sixthsense :) Re: Network Days Formula Help 05-31-2013, 05:34 AM
  1. 05-31-2013, 05:17 AM #1
    robertguy is offline
    Forum Contributor
    Join Date
    02-09-2004
    Location
    Cardiff - Wales - UK
    MS-Off Ver
    2013
    Posts
    475

    Question Network Days Formula Help

    Hi,

    I have the folllowing formula which works fine but if there is no date in cell I7 it gives the me a value of “- 29589”

    =IF((NETWORKDAYS(TODAY(),I7))>0,(NETWORKDAYS(TODAY(),I7)- 1),(NETWORKDAYS(TODAY(),I7)+1))Can any please advise me how I could amend the formula to check that if there is no date in cell I7 to enter the text ‘No Date’ rather than the “- 29589”

    Any assistance would be greatly appreaiated

    Many thanks in advance

    Regards


    N.B Excel Version 2003
    Last edited by robertguy; 05-31-2013 at 05:29 AM. Reason: Solved
    Rob
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1