datedif function, how do I hide #num! error?

Copper Contributor

I'm trying to calculate number of days, but it may be days before the 2nd date is keyed in. How do I hide the error in the cell until the date is added to complete the formula?

1 Reply

Hi,

 

You may use IFERROR around the DATEDIF