Display days between two dates

[vinbg]

Hello excel gurus!

I am using a function to calculate the days between two dates: =NETWORKDAYS(A2,B2)

In this case I have a date in A2 and another in B2 and in C2 i'm displaying the number of days.

However, if there is no value in one of the date fields (A2 or B2) it displays the error #VALUE! in C2.

I know there is a workaround but i'm curious if there is a way to use an IF function in combination with NETWORKDAYS in the same column OR I have to create another column with function IFERROR so it won't display the #VALUE (For example column D2 with =IFERROR(C2,""))

What do you think?

Thanks in advance!

[TPDave]

Please Login or Register  to view this content.

[Tony Valko]

Why don't you just do this:

=IFERROR(NETWORKDAYS(A2,B2),"")

Or...

=IF(COUNT(A2,B2)<2,"",NETWORKDAYS(A2,B2))

[vinbg]

Thanks guys, didn't knew you can use it like this =IFERROR(Networkdays...).

[Tony Valko]

You're welcome. Thanks for the feedback!