Home

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

wuzmop
Occasional Contributor

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

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

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

Hi,

 

You may use IFERROR around the DATEDIF

Related Conversations
DATEDIF's known issue in "md" unit
Haytham Amairah in Formulas and Functions on
0 Replies