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”

Please Login or Register  to view this content.

=IF((NETWORKDAYS(TODAY(),I7))>0,(NETWORKDAYS(TODAY(),I7)- 1),(NETWORKDAYS(TODAY(),I7)+1))

Please Login or Register  to view this content.

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

Try this...

Formula:

Please Login or Register  to view this content.

Sixthsense

you must have know I was going to post my question as you answered it in record time....And guess what ? It's just what I wanted and works a treat

Many thanks indeed


Regards

Rob

Glad it helps you and thanks for the feedback and rep