Home

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

wuzmop
New 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
Planner won't load in Teams
Brandon Laferriere in Microsoft Teams on
10 Replies
OCM encountered an error. Won't start.
Brett Stacey in Outlook Customer Manager on
3 Replies
No Assignments Tab in Microsoft Teams
Nick Davies in Microsoft Teams on
25 Replies
IFERROR - HLOOKUP- IF formula error
data24365 in Formulas and Functions on
14 Replies
Create private channel in a team
Catalin Prata in Microsoft Teams on
59 Replies
Server Error in Stream App
Lukas Ott in Archived on
1 Replies