How can I hide the #NUM! or improve my formula to not show it

[seansr]

I have a spreadsheet that calculates the number of working days from a planned go live day using =Workday.intl but where there is no go live date it is showing #NUM!

is there any way to hide this or can I use a better formular to not show it?

 

[Deepak]

Warp it with iferror

=IFERROR(WORKDAY.INTL($I3,-9,1,Sheet3!$I$2:$I$29),"")

 

[seansr]

Brilliant - Thanks that really helpful

One hopefully quick one - any way how I can either not show the 00/01/1900 date in column Q or format so it can't be seen, Its based on the same formula as the rest but based on the start date.
Tried conditional formatting but that doesn't seems to work

 

[vletm]

@seansr - case '00/01/1900' unmark 'Show zero values'

 

[Khalid NGO]

Brilliant - Thanks that really helpful

One hopefully quick one - any way how I can either not show the 00/01/1900 date in column Q or format so it can't be seen, Its based on the same formula as the rest but based on the start date.
Tried conditional formatting but that doesn't seems to work

Hi,
00/01/1900 means zero value which is formatted to date.

You can use custom format also
Go to format cell
Number tab
Custom:

dd/mm/yyyy;;

Regards,