Eliminating #Value!" message

[davidingilbert]

Hello all.
I am attempting to do a spreadsheet that calculates between two dates. For the calculations between two dates I am using the formula: =NETWORKDAYS.INTL(C2,D2,1,$O$2:$O$12)
However, I do not have values in the all the fields the formula is referencing. Therefore, I am getting the "#Value!" error message.

What I am trying to do come up with a formula to eliminate the error. I think I need to use the "If" formula, but not sure.

Any help you guys can give would be great!

Thanks.
Dave

[twhite2575]

Use the IFERROR function

=IFERROR(NETWORKDAYS.INTL(C12,D12,1,$O$2:$O$12),"")

[tstretch]

=Iferror(NETWORKDAYS.INTL(C2,D2,1,$O$2:$O$12),"Data not available")

[davidingilbert]

Thank you Twhite.

[TMS]

You can either use IFERROR or use

Please Login or Register  to view this content.

or use

Please Login or Register  to view this content.

Regards, TMS