Return blank cell if 0 value when using =NETWORKDAYS formula

[Kerry1980]

Hello,

I have yet another formula question.

I have a set of columns which calculate the number of working days passed based on dates in other columns. I use the following formula:

=NETWORKDAYS(AW5,AX5)

I'd like to amend this formula so that when the number returned is zero, it leaves the cell blank instead of inserting zero. Is this possible?

Many thanks,

Kerry

[Fluff13]

Maybe

Please Login or Register  to view this content.

[dflak]

Try =IF(NETWORKDAYS(AW5,AX5)=0,"",NETWORKDAYS(AW5,AX5))

A bit kludgy, but it should work.

[Kerry1980]

Thank you, both those solutions work!

[Richard Buttrey]

Have you considered turning of the setting for "Show a zero in cells that have a zero value"?

File...Options...Advanced...Display options for this worksheet.

Alternatively

=IF(NETWORKDAYS(AW5,AX5)=0,"",NETWORKDAYS(AW5,AX5))

[Fluff13]

Glad to help & thanks for the feedback.

[Kerry1980]

I didn't know I could do this, so thanks as it'll be useful in future, but for this worksheet, which is huge and has a lot of data, I need the zero's in other cells.

Thanks,

Kerry